eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.ALL_SNAPSHOTS

Object Details

Object Name:	ALL_SNAPSHOTS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Snapshots the user can access

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the snapshot
NAME	VARCHAR2	(128)	Yes	The view used by users and applications for viewing the snapshot
TABLE_NAME	VARCHAR2	(128)	Yes	Table the snapshot is stored in -- has an extra column for the master rowid
MASTER_VIEW	VARCHAR2	(128)		View of the master table, owned by the snapshot owner, used for refreshes
MASTER_OWNER	VARCHAR2	(128)		Owner of the master table
MASTER	VARCHAR2	(128)		Name of the master table that this snapshot is a copy of
MASTER_LINK	VARCHAR2	(128)		Database link name to the master site
CAN_USE_LOG	VARCHAR2	(3)		If NO, this snapshot is complex and will never use a log
UPDATABLE	VARCHAR2	(3)		If NO, the snapshot is read only. Look up REPLICATION
REFRESH_METHOD	VARCHAR2	(11)		The values used to drive a fast refresh of the snapshot
LAST_REFRESH	DATE			SYSDATE from the master site at the time of the last refresh
ERROR	NUMBER			The error returned last time an automatic refresh was attempted
FR_OPERATIONS	VARCHAR2	(10)
CR_OPERATIONS	VARCHAR2	(10)
TYPE	VARCHAR2	(8)		The type of refresh (complete,fast,force) for all automatic refreshes
NEXT	VARCHAR2	(200)		The date function used to compute next refresh dates
START_WITH	DATE			The 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	(128)		The name of the trigger which fills the UPDATE_LOG
UPDATE_LOG	VARCHAR2	(128)		The table which logs changes made to an updatable snapshots
QUERY	LONG	(0)		The original query that this snapshot is an instantiation of
MASTER_ROLLBACK_SEG	VARCHAR2	(128)		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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      NAME
,      TABLE_NAME
,      MASTER_VIEW
,      MASTER_OWNER
,      MASTER
,      MASTER_LINK
,      CAN_USE_LOG
,      UPDATABLE
,      REFRESH_METHOD
,      LAST_REFRESH
,      ERROR
,      FR_OPERATIONS
,      CR_OPERATIONS
,      TYPE
,      NEXT
,      START_WITH
,      REFRESH_GROUP
,      UPDATE_TRIG
,      UPDATE_LOG
,      QUERY
,      MASTER_ROLLBACK_SEG
,      STATUS
,      REFRESH_MODE
,      PREBUILT
FROM SYS.ALL_SNAPSHOTS;

Dependencies

[top of page]

SYS.ALL_SNAPSHOTS references the following:

SYS: DBA_SNAPSHOTS; OBJ$; OBJAUTH$; USER$

SYS.ALL_SNAPSHOTS is referenced by following:

PUBLIC: ALL_SNAPSHOTS
SYS: DBMS_COMPARISON - show dependent code; DBMS_OFFLINE_RGT_INTERNAL - show dependent code; DBMS_REPCAT_UTL - show dependent code