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.
Latest posts by Nagulu Polagani (see all)
- Oracle E-Business Suite 12.2.6 VM Template Deployment - May 6, 2017
- Weblogic Zero Downtime Patching - May 1, 2017
- OAM Integration With Oracle Apps R12.2.x - March 10, 2017