[Home] [Help] [Dependency Information]
Object Name: | DBA_SNAPSHOT_LOGS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All snapshot logs in the database
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 |
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.DBA_SNAPSHOT_LOGS;
|
|
|