Database Link Issues Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Database Link Issues

  1. #1
    Join Date
    Apr 2011

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


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

  2. #2
    Join Date
    May 2002
    Why are you using an URL?

  3. #3
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    Quote Originally Posted by stecal View Post
    Why are you using an 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.

  4. #4
    Join Date
    May 2002
    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

Click Here to Expand Forum to Full Width