Database Link Issues
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???
Why are you using an Oracle.com URL?
Please tell me poster doesn't work for Oracle - pretty please!
Originally Posted by stecal
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
I know you've seen that before...
Click Here to Expand Forum to Full Width