How to change the password of a DB Link in Oracle


How to change the password of a DB Link in Oracle?

Alter Database Link to Change Password

Sometimes, when we use alter database link command, it will show below error:

SQL> ALTER DATABASE LINK APPS_SME.SAMPLE.COM CONNECT TO hr IDENTIFIED BY hr;
ALTER DATABASE LINK APPS_SME.SAMPLE.COM CONNECT TO hr IDENTIFIED BY hr
*
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE

It is because alter database link command is 11G R2 new feature, it won’t work with previous releases.

In this case, we need to drop the link and recreate the link.


Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."