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.