Wednesday, May 9, 2012

Db links -- 11gR2

 No need to drop and re-create the DB link -- Cool


11gR2-- The ALTER DATABASE LINK statement is used to update database links with the
current passwords of connection and authentication users.

ALTER PUBLIC DATABASE LINK public_link
  CONNECT TO scott IDENTIFIED BY scott_new_password;

No comments:

Post a Comment