April 1999
Intermediate to advanced
552 pages
15h 39m
English
---------------------------------------------------------------------------
-- 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(+)
/