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@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/38542/viewspace-1049925/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/38542/viewspace-1049925/