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


TABLE: SYSTEM.REPCAT$_REPPROP

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

Propagation information about replicated objects

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: REPCAT$_REPPROP_PRIMARY
  1. ColumnSNAME
  2. ColumnONAME
  3. ColumnTYPE
  4. ColumnDBLINK
Indexes
Index Type Uniqueness Tablespace Column
REPCAT$_REPPROP_PRIMARY NORMAL UNIQUE TablespaceSYSTEM ColumnSNAME
ColumnONAME
ColumnTYPE
ColumnDBLINK
REPCAT$_REPPROP_DBLINK_HOW NORMAL NONUNIQUE TablespaceSYSTEM ColumnDBLINK
ColumnHOW
ColumnEXTENSION_ID
ColumnRECIPIENT_KEY
REPCAT$_REPPROP_KEY_INDEX NORMAL NONUNIQUE TablespaceSYSTEM ColumnRECIPIENT_KEY
REPCAT$_REPPROP_PRNT2_IDX NORMAL NONUNIQUE TablespaceSYSTEM ColumnSNAME
ColumnDBLINK
REPCAT$_REPPROP_PRNT_IDX NORMAL NONUNIQUE TablespaceSYSTEM ColumnSNAME
ColumnONAME
ColumnTYPE
Foreign Keys
Table
Foreign Table Foreign Key Column
REPCAT$_REPPROP REPCAT$_REPPROP_PRNT TableREPCAT$_REPOBJECT REPCAT$_REPPROP SNAME
REPCAT$_REPPROP ONAME
REPCAT$_REPPROP TYPE
Columns
Name Datatype Length Mandatory Comments
SNAME VARCHAR2 (128) Yes Name of the object owner
ONAME VARCHAR2 (128) Yes Name of the object
TYPE NUMBER
Yes Type of the object
DBLINK VARCHAR2 (128) Yes Destination database for propagation
HOW NUMBER

Propagation choice for the destination database
PROPAGATE_COMMENT VARCHAR2 (80)
Description of the propagation choice
DELIVERY_ORDER NUMBER

Value of delivery order when the master was added
RECIPIENT_KEY NUMBER

Recipient key for sname and oname, used in joining with def$_aqcall
EXTENSION_ID RAW (16)
Identifier of any active extension request
Query Text

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


SELECT SNAME
,      ONAME
,      TYPE
,      DBLINK
,      HOW
,      PROPAGATE_COMMENT
,      DELIVERY_ORDER
,      RECIPIENT_KEY
,      EXTENSION_ID
FROM SYSTEM.REPCAT$_REPPROP;

Dependencies

[top of page]

SYSTEM.REPCAT$_REPPROP does not reference any database object

SYSTEM.REPCAT$_REPPROP is referenced by following:

SchemaSYS
Package BodyDBMS_DEFER_DEFINER - show dependent code
Package BodyDBMS_DEFER_QUERY_UTL - show dependent code
Package BodyDBMS_DEFER_REPCAT - show dependent code
Package BodyDBMS_DEFER_SYS_DEFINER - show dependent code
Package BodyDBMS_DEFER_SYS_PART1 - show dependent code
Package BodyDBMS_OFFLINE_RGT_INTERNAL - show dependent code
Package BodyDBMS_REPCAT_ADD_MASTER - show dependent code
Package BodyDBMS_REPCAT_MAS - show dependent code
Package BodyDBMS_REPCAT_MIG_INTERNAL - 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
ViewDEFCALLDEST
ViewREPCAT_REPPROP
View_DEFTRANDEST