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 |