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
  • 1. Re: alter database link
    Sunny kichloo Expert
    Currently Being Moderated
    You can't change connection string.You have to create new database link.

    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

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



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