-
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?
-
Originally Posted by stecal
Why are you using an Oracle.com URL?
Please tell me poster doesn't work for Oracle - pretty please!
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|