set pages 0
set linesize 200
set feedback off
spool db_links_backup.sql
select 'create database link ' || db_link || ' connect to ' || username || ' identified by <password> using ''' || host || ''';'
from dba_db_links
where owner = 'PUBLIC';
spool off;
No comments:
Post a Comment