Saturday, 18 January 2025

Backup Database Link Before Cloning & create them back after clone.

 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