DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: alter db link

  1. #1
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Hi Friends..

    Is it possible to alter a db_link to make it a pulic one without having to rectreate it.

    alter database link etc etc

    Can someone please give me the syntax.

    Thanks

    Suresh

    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  2. #2
    Join Date
    Oct 2001
    Posts
    83
    Hello,

    I think that the command :

    ALTER DATABASE LINK ...

    does not exist ...

    So you have to recreat the db link ...

    Hope this helps

    Regards

  3. #3
    Join Date
    Nov 2001
    Posts
    335
    Database links cannot be altered, they can only be created and dropped. You can first create a public link and then drop a private one.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Thanks
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

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