Creating a database link in oracle gives the error -
create database link orcl connect to myuser identified by oracle using 'orcl';
SQL Error: ORA-02082: a loopback database link must have a connection qualifier
02082. 00000 - "a loopback database link must have a connection qualifier"
*Cause: attempt to create a database link with the same name as the
current database.
*Action: a loopback database link needs a trailing qualifier, e.g.
MYDB.DEV.US.ORACLE.COM@INST1 - the '@INST1' is the qualifier
To fix use
create database link orcl@loopback connect to myuser identified by oracle using 'orcl';
No comments:
Post a Comment