Introduction to Oracle ALTER DATABASE LINK statement

                             Introduction to Oracle ALTER DATABASE LINK statement

Typically, when you create a database link that connects through a user to a remote database, the user is dedicated and not used by anyone else.

However, if the user is also used by someone, then potentially the user's password could be changed, thereby breaking the database link.

When the password of the user of a database link changes, you need to use the ALTER DATABASE LINK statement to update the database link.

The following statement updates the new password for the remote user of a private database link:

ALTER DATABASE LINK private_dblink CONNECT TO remote_user IDENTIFIED BY new_password;

ALTER PUBLIC DATABASE LINK public_dblink CONNECT TO remote_user IDENTIFIED BY new_password;

                         Oracle ALTER DATABASE LINK statement example

This example uses the ALTER DATABASE LINK statement to update the password for the user saurabh of the M2APPS_to_N2APPS database link:

ALTER DATABASE LINK M2APPS_to_N2APPS  CONNECT TO XYZ IDENTIFIED BY xyz@432;