1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Ora-02085

Discussion in 'SQL PL/SQL' started by Tariq Bashir Malhi, Apr 15, 2010.

  1. Tariq Bashir Malhi

    Tariq Bashir Malhi Forum Advisor

    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    80
    While creating database link i am geting ORA-02085 error, i need help to resolve this...
    in my database global_names = true, i want to keep it TRUE
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You need to recreate the link with the global name of the destination database.
     
    Tariq Bashir Malhi likes this.