Table: DBA_SNAPSHOT_LOGS
All snapshot logs in the database
Column Name | Description |
---|---|
CURRENT_SNAPSHOTS | One date per snapshot -- the date the snapshot of the master last refreshed |
FILTER_COLUMNS | If YES, the snapshot log records filter column information |
INCLUDE_NEW_VALUES | If YES, the snapshot log records old and new values (else only old values) |
LOG_OWNER | Owner of the snapshot log |
LOG_TABLE | Log table; with rowids and timestamps of rows which changed in the master |
LOG_TRIGGER | An after-row trigger on the master which inserts rows into the log |
MASTER | Name of the master table which changes are logged |
OBJECT_ID | If YES, the snapshot log records object id information |
PRIMARY_KEY | If YES, the snapshot log records primary key information |
ROWIDS | If YES, the snapshot log records rowid information |
SEQUENCE | If YES, the snapshot log records sequence information |
SNAPSHOT_ID | Unique identifier of the snapshot |