Management on database link

In a distributed database environment, using database link is a good choice, but sometimes It's tough for us to manage and maintain it. for example, if we change the password of source db name, we need to change it in target db source as well. Before Oracle version 11g, we must delete the link then create a new link to do so, but from Oracle 11.2 on, we can directly alter the database link to change the password. like that:

alter database link dblinkname

connect to test

identified by newpsw;

And if your db link is created in PUBLIC schema, you should login into database using SYSOPER, then have the privilege of altering database link to do so.

[@more@]