home - keyword index

Keyword: SNAPSHOT

jump to Columns back to index

Tables

Table Name Description
ALL_REGISTERED_SNAPSHOTS Remote snapshots of local tables that the user can see
ALL_SNAPSHOTS Snapshots the user can access
ALL_SNAPSHOT_LOGS All snapshot logs in the database that the user can see
ALL_SNAPSHOT_REFRESH_TIMES Synonym for ALL_MVIEW_REFRESH_TIMES
DBA_REGISTERED_SNAPSHOTS Remote snapshots of local tables
DBA_REGISTERED_SNAPSHOT_GROUPS Snapshot repgroup registration information
DBA_SNAPSHOTS All snapshots in the database
DBA_SNAPSHOT_LOGS All snapshot logs in the database
DBA_SNAPSHOT_LOG_FILTER_COLS Synonym for DBA_MVIEW_LOG_FILTER_COLS
DBA_SNAPSHOT_REFRESH_TIMES Synonym for DBA_MVIEW_REFRESH_TIMES
USER_REGISTERED_SNAPSHOTS Remote snapshots of local tables currently using logs owned by the user
USER_SNAPSHOTS Snapshots the user can look at
USER_SNAPSHOT_LOGS All snapshot logs owned by the user
USER_SNAPSHOT_REFRESH_TIMES Synonym for USER_MVIEW_REFRESH_TIMES
top back to index

Columns

Column Name Description
CURRENT_SNAPSHOTS (ALL_SNAPSHOT_LOGS) One date per snapshot -- the date the snapshot of the master last refreshed
CURRENT_SNAPSHOTS (DBA_SNAPSHOT_LOGS) One date per snapshot -- the date the snapshot of the master last refreshed
CURRENT_SNAPSHOTS (USER_SNAPSHOT_LOGS) Dates that all known simple snapshots last refreshed
SNAPMASTER (DBA_REPSITES) For a snapshot site, is the database the current refresh master
SNAPMASTER (ALL_REPSCHEMA) For a snapshot site, is the database the current refresh master
SNAPMASTER (DBA_REPSCHEMA) For a snapshot site, is the database the current refresh master
SNAPMASTER (USER_REPSCHEMA) For snapshot sites, is the database the current refresh master
SNAPMASTER (ALL_REPSITES) For a snapshot site, is the database the current refresh master
SNAPMASTER (USER_REPSITES) For snapshot sites, is the database the current refresh master
SNAPSHOT_ID (USER_REGISTERED_SNAPSHOTS) Identifier for the snapshot used by the master for fast refresh
SNAPSHOT_ID (DBA_REGISTERED_SNAPSHOTS) Identifier for the snapshot used by the master for fast refresh
SNAPSHOT_ID (ALL_SNAPSHOT_LOGS) Unique identifier of the snapshot
SNAPSHOT_ID (ALL_REGISTERED_SNAPSHOTS) Identifier for the snapshot used by the master for fast refresh
SNAPSHOT_ID (USER_SNAPSHOT_LOGS)
SNAPSHOT_ID (DBA_SNAPSHOT_LOGS) Unique identifier of the snapshot
SNAPSHOT_SITE (USER_REGISTERED_SNAPSHOTS) Global name of the snapshot site
SNAPSHOT_SITE (ALL_REGISTERED_SNAPSHOTS) Global name of the snapshot site
SNAPSHOT_SITE (DBA_REGISTERED_SNAPSHOT_GROUPS) Database site of the snapshot repgroup
SNAPSHOT_SITE (DBA_REGISTERED_SNAPSHOTS) Global name of the snapshot site
top back to index

Comment on this page:




home - keyword index