April 1999
Intermediate to advanced
552 pages
15h 39m
English
Content preview from Oracle Distributed SystemsBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
snaps7.sql
---------------------------------------------------------------------------
-- Filename: snaps7.sql
-- Purpose: Lists all snapshots in the database.
-- Author Chas. Dye (cdye@excitecorp.com)
-- Date: 17-Jan-1997
---------------------------------------------------------------------------
column owner format a9
column name format a15
column table_name format a27
column link format a5 heading "Link"
column last_refresh format a20
SELECT owner,
name,
table_name,
substr(master_link, 1, 5) link,
to_char(last_refresh, 'DD-Mon-YYYY hh24:mi:ss') last_refresh
FROM dba_snapshots
ORDER BY owner, name
/