快捷搜索:  as  2018  FtCWSyGV  С˵  test  xxx  Ψһ  w3viyKQx

ag手机客户端最新版本_数据库链接的备份脚本



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

Description: This script produces readableag手机客户端最新版本 output (backupag手机客户端最新版本) for database linkag手机客户端最新版本s 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_NAME

select name from sys.v_$database;

set lines 80

col TEXT for a70

spool &DB_NAME..DB_LINKS.lst

select

'--'

||CHR(10)

||'-- Owner is ' || U.NAME

||CHR(10)

||'-- DB Link is'|| L.NAME

||CHR(10)

||'--'

||CHR(10)

||'create &ag手机客户端最新版本#39;||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

'''|ag手机客户端最新版本|L.PASSWORD||''' using ''' || L.host || ''''

||chr(10)||';'

TEXT

from sys.link$ L,

sys.user$ U

where L.OWNER# = U.USER#

;

spool off

您可能还会对下面的文章感兴趣: