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


VIEW: SYS.DBA_REGISTERED_SNAPSHOT_GROUPS

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

Snapshot repgroup registration information

[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (30)
Name of the snapshot repgroup
SNAPSHOT_SITE VARCHAR2 (128)
Database site of the snapshot repgroup
GROUP_COMMENT VARCHAR2 (80)
Description of the snapshot repgroup
VERSION VARCHAR2 (8)
Version of the snapshot repgroup
FNAME VARCHAR2 (30)
Name of the flavor of the snapshot repgroup
OWNER VARCHAR2 (128)
Owner of the snapshot repgroup
Query Text

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


SELECT NAME
,      SNAPSHOT_SITE
,      GROUP_COMMENT
,      VERSION
,      FNAME
,      OWNER
FROM SYS.DBA_REGISTERED_SNAPSHOT_GROUPS;

Dependencies

[top of page]

SYS.DBA_REGISTERED_SNAPSHOT_GROUPS references the following:

SchemaSYSTEM
TableREPCAT$_FLAVORS
TableREPCAT$_SNAPGROUP
SYS.DBA_REGISTERED_SNAPSHOT_GROUPS is referenced by following:

SchemaPUBLIC
SynonymDBA_REGISTERED_SNAPSHOT_GROUPS