Script to generate sql to unregister snapshots in Oracle database
select 'exec DBMS_SNAPSHOT.UNREGISTER_SNAPSHOT(snapowner => ' || '''' || owner ||
'''' || ', snapname => ' || '''' || name || '''' || ', snapsite => ' || '''' ||
snapshot_site || '''' || ');'
from dba_registered_snapshots
/
|