当前位置:数据库 > Oracle >>

数据库链接的备份脚本

答案:

  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.linuxpk.com/78018.html
发表您的高见!

上一个:在不同字符集的数据库之间导入数据的方法
下一个:Oracle自动备份数据

CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,