DATABASE SNAPSHOT NOTES

 

Snapshots

DATABASE SNAPSHOT NOTES:

Owner - Owner of the snapshot

Name - The view used by users and applications for viewing the snapshot

Table Name - Table the snapshot is stored in, has an extra column for the master rowid

Master View - View of the master table, owned by the snapshot owner, used for refreshes

Master Owner - Owner of the master table

Master - Name of the master table of which this snapshot is a copy

Master Link - Database link name to the master site

Can Use Log - If NO, this snapshot is complex and will never use a log

Updatable - If NO, the snapshot is read only

Last Refresh - SYSDATE from the master site at the time of the last refresh

Error - The number of failed automatic refreshes since last successful refresh

Type - The type of refresh (complete, fast, force) for all automatic refreshes

Next Refresh - The date function used to compute next refresh dates

Refresh Group - GROUP All snapshots in a given refresh group get refreshed in the same transaction

select 
OWNER,
 NAME,
 TABLE_NAME,
 MASTER_VIEW,
 MASTER_OWNER,
 MASTER,
 MASTER_LINK,
 CAN_USE_LOG,
 UPDATABLE,
 LAST_REFRESH,
 ERROR,
 TYPE,
 NEXT,
 REFRESH_GROUP
from   dba_snapshots
order  by OWNER,NAME