Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with creating db link

519623Apr 11 2007 — edited Dec 11 2008

Hi Everybody,

I have two databases: testdbA and testdbB. I would like to create db link in testdbA to testdbB.

My Oracle init parameters in both databases are the following:
db_domain = NULL
db_name = testdbA
global_names = FALSE

In spite of global_names is set to FALSE when i create the public database link on testdbA database, as follows:
CREATE PUBLIC DATABASE LINK TEST CONNECT TO CURRENT_USER USING 'testdbB';
The created db link with the above command will be TEST concatenated with REGRESS.RDBMS.DEV.US.ORACLE.COM.

How could i get rid of that domain???
Thanks in advance for your help,
Zeni

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2009

Added on Apr 11 2007

#database-key-features, #replication

11 comments

11,704 views