Static Data Dictionary Views, 74 of 452

ALL_SNAPSHOT_LOGS

ALL_SNAPSHOT_LOGS lists all snapshot logs accessible to the current user.

USER_SNAPSHOT_LOGS describes all snapshot logs owned by the current user.

Column	Datatype	NULL	Description
`LOG_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the log
`MASTER`	`VARCHAR2(30)`	`NOT NULL`	Name of the master table whose changes are logged
`LOG_TABLE`	`VARCHAR2(30)`	`NOT NULL`	Name of the table where the changes to the master table are recorded
`LOG_TRIGGER`	`VARCHAR2(30)`		Obsolete with the release of Oracle8i Server. Set to NULL. Formerly, this parameter was an after-row trigger on the master which inserted rows into the log
`ROWIDS`	`VARCHAR2(3)`		If YES, records ROWID information
`PRIMARY_KEY`	`VARCHAR2(3)`		If YES, records primary key information
`FILTER_COLUMNS`	`VARCHAR2(3)`		If YES, snapshot log records filter columns
`CURRENT_SNAPSHOTS`	`DATE`		One date per snapshot; the date the snapshot of the master was last refreshed
`SNAPSHOT_ID`	`NUMBER(38)`		Unique identifier of the snapshot