Data Dictionary Views, 96 of 112

ALL_SNAPSHOT_LOGS

Lists all snapshot logs accessible to the current user.

This view shows one row for each snapshot using the snapshot log. However, there is only one log for all the snapshots located at the master site. To find out which logs are used, query USER_SNAPSHOT_LOGS using unique without selecting SNAPSHOT_ID and CURRENT_SNAPSHOTS.

Related views:

DBA_SNAPSHOT_LOGS describes all snapshot logs in the database.

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.

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.