I was establishing database link for Oracle Streams and got the following error:
ora-02085: database link <>.REGRESS.RDBMS.DEV.US.ORACLE.COM connects to < >
The SQL for creation of db link is:
CREATE database link <> connect to scott identified by tiger using < >
I set the GLOBAL_NAMES to true and the following query results in <>
SELECT * FROM GLOBAL_NAME;
returns <>, without any extension.
but the select db_link from dba_db_links returns <>.REGRESS.RDBMS,DEV.US.ORACLE.COM.
Going crazy by that additional info added to DBNAME.
How can I setup the db link now???
