Oracle Database Discussions

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!

Db link creation in same db.

617891Jun 9 2008 — edited Oct 20 2008

I am trying to create dblink in the same db between schemas . One schema name is clidev2 and other is dbmig. But when i am creating getting below error.
Please some one tell me that how can i create db links between the scheams .I have to create dbling from clidev2 to dbming and dbming to clidev2

SQL> create public database link BFIP.BIGFOOTINTERACTIVE.COM connect to clidev2 identified by clidev2 using bfip;
create public database link BFIP.BIGFOOTINTERACTIVE.COM connect to clidev2 identified by clidev2 using bfip
*
ERROR at line 1:
ORA-02082: a loopback database link must have a connection qualifier

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 17 2008

Added on Jun 9 2008

#general-database-discussions

9 comments

2,250 views