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???