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

VIEW: SYS.DBA_REGISTERED_SNAPSHOTS

Object Details
Object Name: DBA_REGISTERED_SNAPSHOTS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Remote snapshots of local tables

[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, 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.DBA_REGISTERED_SNAPSHOTS;

Dependencies

[top of page]

SYS.DBA_REGISTERED_SNAPSHOTS references the following:

SchemaSYS
TableREG_SNAP$
SYS.DBA_REGISTERED_SNAPSHOTS is referenced by following:

SchemaPUBLIC
SynonymDBA_REGISTERED_SNAPSHOTS
SchemaSYS
ViewALL_REGISTERED_SNAPSHOTS
Package BodyDBMS_REPCAT_UTL - show dependent code
ViewUSER_REGISTERED_SNAPSHOTS