Results 1 to 2 of 2

Thread: Ora-02085

  1. #1
    Join Date
    Jan 2004

    Unanswered: Ora-02085

    I have folowed hetrogenous database link manuals and created a link from oracle 8.1.7 to sql2000

    However when i execute select satement I get error:
    ORA-02085 database link REDROUTER.WORLD connects to HO.WORLD

    I am using name 'REDROUTER' throughout my setup for ODBC, tnsnames, listener and link. REDROUTER is also sql2000 database name i am trying to link to.

    Any ideas?

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    // *Cause: a database link connected to a database with a different name.
    // The connection is rejected.
    // *Action: create a database link with the same name as the database it
    // connects to, or set global_names=false.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts