当前位置:操作系统 > Unix/Linux >>

数据库链接的备份脚本

This tip comes from Galina Petrenko, Sr. IT Specialist, TPAS Systems Development, at Towers Perrin, in Voorhees, NJ.

  Description: This script produces readable output (backup) for database links in the database. It can be used in the restore/recovery process. Note that passwords for database links are also spooled in a readable format.

  col NAME new_value DB_NAMEselect name from sys.v_$database;set lines 80col TEXT for a70spool &DB_NAME..DB_LINKS.lstselect'--'||CHR(10)||'-- Owner is ' || U.NAME||CHR(10)||'-- DB Link is'|| L.NAME||CHR(10)||'--'||CHR(10)||'create '||DECODE(U.NAME,'PUBLIC','public')||' database link '||CHR(10)||DECODE(U.NAME,'PUBLIC',Null, U.NAME||'.')|| L.NAME||chr(10)||'connect to ' || L.USERID || ' identified by'''||L.PASSWORD||''' using ''' || L.host || ''''||chr(10)||';'TEXTfrom sys.link$ L,sys.user$ Uwhere L.OWNER# = U.USER#;spool off本文来自:http://doc.xiaoyaxiao.com/78018.html
发表您的高见!
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,