Database links after database filecopy
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Database links after database filecopy

  1. #1
    Join Date
    Aug 2005
    Location
    Luxembourg, Europe
    Posts
    2

    Cool Database links after database filecopy

    Hello,

    I recently set up a new Oracle database through a filecopy of all files. The database works fine (global_name looks fine, tnsnames.ora also).

    On the source database (assume PRD.world) there was a database link to a remote database (assume VTT.world) and vice versa.

    Now, through filecopy, the database link to the remote database (VTT.world) is on the same server. It so reacts as a loopback-database-link now.

    And here's my problem:
    If I try to drop the public database link on the VTT.world, Oracle tells me:

    DROP PUBLIC DATABASE LINK vtt;

    ERROR : ORA-02082: a loop-back database link must have a connection qualifier

    It seems, after searching for this topic in different Newsgroups, that this loopback-link couldn't be dropped anymore

    Thanks for advice,
    romain.

  2. #2
    Join Date
    Jan 2003
    Location
    Bahrain
    Posts
    109
    Hope this helps in your situation.

    select * from global_name;

    alter database rename global_name to test;
    drop database link vtt;


    Once the link is dropped, you can rename the global name back.

    Regards,
    Seelan

  3. #3
    Join Date
    Aug 2005
    Location
    Luxembourg, Europe
    Posts
    2
    Some things are so easy and only look so difficult to resolve

    Thank you!

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