[Home] [Help] [Dependency Information]
Object Name: | REPCAT$_REPSCHEMA |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
N-way replication information
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
REPCAT$_REPSCHEMA_PRIMARY | NORMAL | UNIQUE | SYSTEM |
SNAME
DBLINK GOWNER |
REPCAT$_REPSCHEMA_DEST_IDX | NORMAL | NONUNIQUE | SYSTEM |
DBLINK
EXTENSION_ID |
REPCAT$_REPSCHEMA_DEST_IDX1 | NORMAL | NONUNIQUE | SYSTEM | DBLINK |
REPCAT$_REPSCHEMA_PRNT_IDX | NORMAL | NONUNIQUE | SYSTEM |
SNAME
GOWNER |
Table | |
Foreign Table | Foreign Key Column | REPCAT$_REPSCHEMA | DEF$_DESTINATION |
REPCAT$_REPSCHEMA
DBLINK
REPCAT$_REPSCHEMA EXTENSION_ID |
REPCAT$_REPSCHEMA | REPCAT$_REPCAT |
REPCAT$_REPSCHEMA
SNAME
REPCAT$_REPSCHEMA GOWNER |
---|
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 |
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;
SYSTEM.REPCAT$_REPSCHEMA does not reference any database object
SYSTEM.REPCAT$_REPSCHEMA is referenced by following:
|
|
|