DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ALL_SNAPSHOT_LOGS

Object Details
Object Name: ALL_SNAPSHOT_LOGS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All snapshot logs in the database that the user can see

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOG_OWNER VARCHAR2 (128)
Owner of the snapshot log
MASTER VARCHAR2 (128)
Name of the master table which changes are logged
LOG_TABLE VARCHAR2 (128)
Log table; with rowids and timestamps of rows which changed in the master
LOG_TRIGGER VARCHAR2 (128)
An after-row trigger on the master which inserts rows into the log
ROWIDS VARCHAR2 (3)
If YES, the snapshot log records rowid information
PRIMARY_KEY VARCHAR2 (3)
If YES, the snapshot log records primary key information
OBJECT_ID VARCHAR2 (3)
If YES, the snapshot log records object id information
FILTER_COLUMNS VARCHAR2 (3)
If YES, the snapshot log records filter column information
SEQUENCE VARCHAR2 (3)
If YES, the snapshot log records sequence information
INCLUDE_NEW_VALUES VARCHAR2 (3)
If YES, the snapshot log records old and new values (else only old values)
CURRENT_SNAPSHOTS DATE

One date per snapshot -- the date the snapshot of the master last refreshed
SNAPSHOT_ID NUMBER

Unique identifier of the snapshot
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOG_OWNER
,      MASTER
,      LOG_TABLE
,      LOG_TRIGGER
,      ROWIDS
,      PRIMARY_KEY
,      OBJECT_ID
,      FILTER_COLUMNS
,      SEQUENCE
,      INCLUDE_NEW_VALUES
,      CURRENT_SNAPSHOTS
,      SNAPSHOT_ID
FROM SYS.ALL_SNAPSHOT_LOGS;

Dependencies

[top of page]

SYS.ALL_SNAPSHOT_LOGS references the following:

SchemaSYS
ViewDBA_SNAPSHOT_LOGS
TableOBJ$
TableOBJAUTH$
TableUSER$
SYS.ALL_SNAPSHOT_LOGS is referenced by following:

SchemaPUBLIC
SynonymALL_SNAPSHOT_LOGS
SchemaSYS
ViewALL_REGISTERED_SNAPSHOTS