ITPub博客

首页 > 数据库 > 数据库开发技术 > Management on database link

Management on database link

原创 数据库开发技术 作者:shiyihai 时间:2011-05-16 10:50:05 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    235
  • 访问量
    1667889