Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    34

    Unanswered: database link help

    Hi Friends.

    How can I create a database link without
    modify tnsnames.ora? (I have not privileges on it).


    Thanks in advance

    Pappagone

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118
    Hi

    [SYSTEM@DB4.ORA-0000.COM:NL-UTH-L057656] CREATE DATABASE LINK TEST
    2 CONNECT TO SYSTEM IDENTIFIED BY REMIVISSER
    3 USING '(description=(address=(protocol=tcp)(host=127.0.0 .1)(port=1521))(connect_data=(sid=DB4)))'
    4 /

    Database link created.


    Good luck

    remi

    http://askremi.ora-0000.com
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •