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


TABLE: SYSTEM.REPCAT$_SNAPGROUP

Object Details
Object Name: REPCAT$_SNAPGROUP
Object Type: TABLE
Owner: SYSTEM
Subobject Name:
Status: VALID

Snapshot repgroup registration information

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
I_REPCAT$_SNAPGROUP1 NORMAL UNIQUE TablespaceSYSTEM ColumnGNAME
ColumnDBLINK
ColumnGOWNER
Columns
Name Datatype Length Mandatory Comments
GOWNER VARCHAR2 (128)
Owner of the snapshot repgroup
GNAME VARCHAR2 (30)
Name of the snapshot repgroup
DBLINK VARCHAR2 (128)
Database site of the snapshot repgroup
GROUP_COMMENT VARCHAR2 (80)
Description of the snapshot repgroup
REP_TYPE NUMBER

Identifier of flavor at snapshot
FLAVOR_ID NUMBER

Query Text

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


SELECT GOWNER
,      GNAME
,      DBLINK
,      GROUP_COMMENT
,      REP_TYPE
,      FLAVOR_ID
FROM SYSTEM.REPCAT$_SNAPGROUP;

Dependencies

[top of page]

SYSTEM.REPCAT$_SNAPGROUP does not reference any database object

SYSTEM.REPCAT$_SNAPGROUP is referenced by following:

SchemaSYS
ViewDBA_REGISTERED_MVIEW_GROUPS
ViewDBA_REGISTERED_SNAPSHOT_GROUPS
Package BodyDBMS_REPCAT_SNA_UTL - show dependent code