This discussion is archived
2 Replies Latest reply: May 9, 2013 6:29 AM by 1006363 RSS

alter database link

user13364377 Newbie
Currently Being Moderated
Hi Team,

Can we alter a public database link to connect to a different db using the below statement?

Alter public database link link_name connect to schema identified by password using 'newdb';

Db version is 10.2.0.4
  • 1. Re: alter database link
    Sunny kichloo Expert
    Currently Being Moderated
    You can't change connection string.You have to create new database link.

    http://docs.oracle.com/cd/E11882_01/server.112/e17118/statements_1005.htm

    Also
          user13364377      
           Newbie
           
    Handle:      user13364377  
    Status Level:      Newbie (10)
    Registered:      Jul 5, 2010
    Total Posts:      340
    Total Questions:      151 (110 unresolved) 
    Why you have so many unresolved thread???

    Try to close your old threads.
  • 2. Re: alter database link
    1006363 Newbie
    Currently Being Moderated
    Hello,

    You need to drop the old and create new public link to connect to a different DB with same DB Link name.

    Regards,
    Chirag

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points