2 Replies Latest reply: May 9, 2013 8:29 AM by 1006363 RSS

    alter database link

    user13364377
      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
          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
            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