Oracle DBA – A lifelong learning experience

Changing a database link password

Posted by John Hallas on February 13, 2015

I recently found out  that it is possible to change a database link password without dropping and recreating a database link in its entirety.

To be honest I thought this might have existed forever and I had just never come across it but it actually come out in 11GR2

The ALTER DATABASE LINK statement can be used and you do not need to specify the target service either  – all you need  is to run the following command from the user that owns a pre-existing database link


I know it is not a major change but a quick canvas amongst fellow DBAs and nobody had noticed it’s arrival either so a heads-up might be helpful to someone


2 Responses to “Changing a database link password”

  1. C. W. said

    So glad that this feature is there. It is definitely helpful when you have to change schema passwords.

    • John Hallas said

      I suspect it came through an enhancement request. I dont know why you cannot see enhancement requests, or even vote on them.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: