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

TABLE: SYSTEM.REPCAT$_REPSCHEMA

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

N-way replication information

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: REPCAT$_REPSCHEMA_PRIMARY
  1. ColumnSNAME
  2. ColumnDBLINK
  3. ColumnGOWNER
Indexes
Index Type Uniqueness Tablespace Column
REPCAT$_REPSCHEMA_PRIMARY NORMAL UNIQUE TablespaceSYSTEM ColumnSNAME
ColumnDBLINK
ColumnGOWNER
REPCAT$_REPSCHEMA_DEST_IDX NORMAL NONUNIQUE TablespaceSYSTEM ColumnDBLINK
ColumnEXTENSION_ID
REPCAT$_REPSCHEMA_DEST_IDX1 NORMAL NONUNIQUE TablespaceSYSTEM ColumnDBLINK
REPCAT$_REPSCHEMA_PRNT_IDX NORMAL NONUNIQUE TablespaceSYSTEM ColumnSNAME
ColumnGOWNER
Foreign Keys
Table
Foreign Table Foreign Key Column
REPCAT$_REPSCHEMA REPCAT$_REPSCHEMA_DEST TableDEF$_DESTINATION REPCAT$_REPSCHEMA DBLINK
REPCAT$_REPSCHEMA EXTENSION_ID
REPCAT$_REPSCHEMA REPCAT$_REPSCHEMA_PRNT TableREPCAT$_REPCAT REPCAT$_REPSCHEMA SNAME
REPCAT$_REPSCHEMA GOWNER
Columns
Name Datatype Length Mandatory Comments
GOWNER VARCHAR2 (128) Yes Owner of the replicated object group
SNAME VARCHAR2 (30) Yes Name of the replicated object group
DBLINK VARCHAR2 (128) Yes A database site replicating the object group
MASTERDEF VARCHAR2 (1)
Is the database the master definition site for the replicated object group
SNAPMASTER VARCHAR2 (1)
For a snapshot site, is this the current refresh_master
MASTER_COMMENT VARCHAR2 (80)
Description of the database site
MASTER VARCHAR2 (1)
Redundant information from repcat$_repcat.master
PROP_UPDATES NUMBER

Number of requested updates for master in repcat$_repprop
MY_DBLINK VARCHAR2 (1)
A sanity check after import: is this master the current site
EXTENSION_ID RAW (16)
Dummy column for foreign key
Query Text

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


SELECT GOWNER
,      SNAME
,      DBLINK
,      MASTERDEF
,      SNAPMASTER
,      MASTER_COMMENT
,      MASTER
,      PROP_UPDATES
,      MY_DBLINK
,      EXTENSION_ID
FROM SYSTEM.REPCAT$_REPSCHEMA;

Dependencies

[top of page]

SYSTEM.REPCAT$_REPSCHEMA does not reference any database object

SYSTEM.REPCAT$_REPSCHEMA is referenced by following:

SchemaSYS
ViewDBA_REPSCHEMA
ViewDBA_REPSITES
Package BodyDBMS_DEFER_REPCAT - show dependent code
Package BodyDBMS_OFFLINE_RGT_INTERNAL - show dependent code
Package BodyDBMS_OFFLINE_SNAPSHOT_INTERNAL - show dependent code
Package BodyDBMS_REPCAT_ADD_MASTER - show dependent code
Package BodyDBMS_REPCAT_COMMON_UTL - show dependent code
Package BodyDBMS_REPCAT_DEFINER - show dependent code
Package BodyDBMS_REPCAT_FLA_MAS - show dependent code
Package BodyDBMS_REPCAT_MAS - show dependent code
Package BodyDBMS_REPCAT_MIGRATION - show dependent code
Package BodyDBMS_REPCAT_MIG_INTERNAL - show dependent code
Package BodyDBMS_REPCAT_RGT_CUST - show dependent code
Package BodyDBMS_REPCAT_RPC - show dependent code
Package BodyDBMS_REPCAT_RPC_UTL - show dependent code
Package BodyDBMS_REPCAT_SNA_UTL - show dependent code
Package BodyDBMS_REPCAT_UTL - show dependent code
Package BodyDBMS_REPCAT_UTL3 - show dependent code
Package BodyDBMS_REPCAT_UTL4 - show dependent code
ViewREPCAT_REPSCHEMA