Static Data Dictionary Views, 76 of 452

ALL_SNAPSHOTS

ALL_SNAPSHOTS describes all snapshots accessible to the user.

Related views:

DBA_SNAPSHOTS describes all snapshots in the database.

USER_SNAPSHOTS describes all snapshots owned by the current user.

Note:
All of the information in these views is also displayed in ALL_MVIEWS and its related views. Oracle Corporation recommends that you refer to ALL_MVIEWS for this information instead of these views.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the snapshot

NAME

VARCHAR2(30)

NOT NULL

Name of the view used by users and applications for viewing the snapshot

TABLE_NAME

VARCHAR2(30)

NOT NULL

Table the snapshot is stored in. This table may have additional columns

MASTER_VIEW

VARCHAR2(30)

View of the master table, owned by the snapshot owner, used for refreshes. This is obsolete in Oracle8i and is set to NULL

MASTER_OWNER

VARCHAR2(30)

Owner of the master table

MASTER

VARCHAR2(30)

Name of the master table of which this snapshot is a copy

MASTER_LINK

VARCHAR2(128)

Database link name to the master site

CAN_USE_LOG

VARCHAR2(3)

YES if this snapshot can use a snapshot log, NO if this snapshot is too complex to use a log

UPDATABLE

VARCHAR2(3)

Specifies whether the snapshot is updatable. YES if it is, NO if it is not. If set to YES, the snapshot is read only

REFRESH_METHOD

VARCHAR2(11)

Values used to drive a refresh of the snapshot (PRIMARY KEY/ROWID/COMPLEX). If PRIMARY KEY, then the snapshot uses primary keys to drive a fast refresh. If ROWID, then it uses RowIDs to drive a fast refresh. If COMPLEX, then fast refreshes are not allowed and the snapshot can only perform complete refreshes

LAST_REFRESH

DATE

Date and time at the master site of the last refresh

ERROR

NUMBER

The number of failed automatic refreshes since last successful refresh

FR_OPERATIONS

VARCHAR2(10)

Status of generated fast refresh operations: (REGENERATE, VALID)

CR_OPERATIONS

VARCHAR2(10)

Status of generated complete refresh operations: (REGENERATE, VALID)

TYPE

VARCHAR2(8)

Type of refresh for all automatic refreshes: COMPLETE, FAST, FORCE

NEXT

VARCHAR2(200)

Date function used to compute next refresh dates

START_WITH

DATE

Date function used to compute next refresh dates

REFRESH_GROUP

NUMBER

All snapshots in a given refresh group get refreshed in the same transaction

UPDATE_TRIG

VARCHAR2(30)

Obsolete. It is NULL for Oracle8i snapshots. Formerly, the name of the trigger that fills the UPDATE_LOG

UPDATE_LOG

VARCHAR2(30)

The table that logs changes made to an updatable snapshots

QUERY

LONG

Original query of which this snapshot is an instantiation

MASTER_ROLLBACK_SEG

VARCHAR2(30)

Rollback segment to use at the master site

STATUS

VARCHAR2(7)

The status of the contents of the snapshot

REFRESH_MODE

VARCHAR2(8)

This indicates how and when the snapshot will be refreshed

PREBUILT

VARCHAR2(3)

If YES, this snapshot uses a prebuilt table as the base table

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the snapshot
`NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the view used by users and applications for viewing the snapshot
`TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Table the snapshot is stored in. This table may have additional columns
`MASTER_VIEW`	`VARCHAR2(30)`		View of the master table, owned by the snapshot owner, used for refreshes. This is obsolete in Oracle8i and is set to NULL
`MASTER_OWNER`	`VARCHAR2(30)`		Owner of the master table
`MASTER`	`VARCHAR2(30)`		Name of the master table of which this snapshot is a copy
`MASTER_LINK`	`VARCHAR2(128)`		Database link name to the master site
`CAN_USE_LOG`	`VARCHAR2(3)`		`YES` if this snapshot can use a snapshot log, `NO` if this snapshot is too complex to use a log
`UPDATABLE`	`VARCHAR2(3)`		Specifies whether the snapshot is updatable. `YES` if it is, `NO` if it is not. If set to `YES`, the snapshot is read only
`REFRESH_METHOD`	`VARCHAR2(11)`		Values used to drive a refresh of the snapshot (`PRIMARY` `KEY`/`ROWID`/`COMPLEX`). If `PRIMARY` `KEY`, then the snapshot uses primary keys to drive a fast refresh. If `ROWID`, then it uses RowIDs to drive a fast refresh. If `COMPLEX`, then fast refreshes are not allowed and the snapshot can only perform complete refreshes
`LAST_REFRESH`	`DATE`		Date and time at the master site of the last refresh
`ERROR`	`NUMBER`		The number of failed automatic refreshes since last successful refresh
`FR_OPERATIONS`	`VARCHAR2(10)`		Status of generated fast refresh operations: (`REGENERATE`, `VALID`)
`CR_OPERATIONS`	`VARCHAR2(10)`		Status of generated complete refresh operations: (`REGENERATE`, `VALID`)
`TYPE`	`VARCHAR2(8)`		Type of refresh for all automatic refreshes: `COMPLETE`, `FAST`, `FORCE`
`NEXT`	`VARCHAR2(200)`		Date function used to compute next refresh dates
`START_WITH`	`DATE`		Date function used to compute next refresh dates
`REFRESH_GROUP`	`NUMBER`		All snapshots in a given refresh group get refreshed in the same transaction
`UPDATE_TRIG`	`VARCHAR2(30)`		Obsolete. It is NULL for Oracle8i snapshots. Formerly, the name of the trigger that fills the `UPDATE_LOG`
`UPDATE_LOG`	`VARCHAR2(30)`		The table that logs changes made to an updatable snapshots
`QUERY`	`LONG`		Original query of which this snapshot is an instantiation
`MASTER_ROLLBACK_SEG`	`VARCHAR2(30)`		Rollback segment to use at the master site
`STATUS`	`VARCHAR2(7)`		The status of the contents of the snapshot
`REFRESH_MODE`	`VARCHAR2(8)`		This indicates how and when the snapshot will be refreshed
`PREBUILT`	`VARCHAR2(3)`		If YES, this snapshot uses a prebuilt table as the base table