April 1999
Intermediate to advanced
552 pages
15h 39m
English
---------------------------------------------------------------------------
-- Filename: regsnaps.sql
-- Purpose: Lists registered snapshots (run from master site).
-- Author: Chas. Dye (cdye@excitecorp.com)
-- Date: 24-Jun-1998
---------------------------------------------------------------------------
column owner heading "Owner" format a8
column name heading "Name" format a20
column snapshot_site heading "Snapshot|Site" format a15
column can_use_log heading "Can|Use|Log" format a3
column updatable heading "Upd" format a3
column refresh_method heading "Refresh|Method" format a11
column version heading "Version" format a10
SELECT owner,
name,
snapshot_site,
can_use_log,
updatable,
refresh_method,
substr(version, 1, 8) version
FROM dba_registered_snapshots
/