regsnaps.sql

---------------------------------------------------------------------------
-- 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
/

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.

Start your free trial