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_REGISTERED_SNAPSHOTS

Object Details

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

Remote snapshots of local tables that the user can see

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the snapshot
NAME	VARCHAR2	(128)	Yes	The name of the snapshot
SNAPSHOT_SITE	VARCHAR2	(128)	Yes	Global name of the snapshot site
CAN_USE_LOG	VARCHAR2	(3)		If NO, this snapshot is complex and cannot fast refresh
UPDATABLE	VARCHAR2	(3)		If NO, the snapshot is read only
REFRESH_METHOD	VARCHAR2	(11)		Whether the snapshot uses rowid or primary key or object id for fast refresh
SNAPSHOT_ID	NUMBER			Identifier for the snapshot used by the master for fast refresh
VERSION	VARCHAR2	(17)		Version of snapshot
QUERY_TXT	LONG	(0)		Query defining the snapshot

Query Text

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


SELECT OWNER
,      NAME
,      SNAPSHOT_SITE
,      CAN_USE_LOG
,      UPDATABLE
,      REFRESH_METHOD
,      SNAPSHOT_ID
,      VERSION
,      QUERY_TXT
FROM SYS.ALL_REGISTERED_SNAPSHOTS;

Dependencies

[top of page]

SYS.ALL_REGISTERED_SNAPSHOTS references the following:

SYS: ALL_SNAPSHOT_LOGS; DBA_REGISTERED_SNAPSHOTS

SYS.ALL_REGISTERED_SNAPSHOTS is referenced by following:

PUBLIC: ALL_REGISTERED_SNAPSHOTS