mastersnapinfo.sql
---------------------------------------------------------------------------
-- Filename: mastersnapinfo.sql
-- Purpose: Lists info about all registered snapshots.
-- Requires Oracle8.
-- Author: Chas. Dye (cdye@excitecorp.com)
-- Date: 28-Jun-1997
---------------------------------------------------------------------------
column owner format a10
column name format a20
column snapshot_site format a15
column current_snapshot format a22
SELECT r.owner,
r.name,
r.snapshot_site,
l.current_snapshots
FROM dba_registered_snapshots r,
dba_snapshot_logs l
WHERE r.snapshot_id = l.snapshot_id(+)
/Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
