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


TABLE: SYSTEM.REPCAT$_GROUPED_COLUMN

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

Columns in all column groups of replicated tables in the database

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: REPCAT$_GROUPED_COLUMN_PK
  1. ColumnSNAME
  2. ColumnONAME
  3. ColumnGROUP_NAME
  4. ColumnCOLUMN_NAME
  5. ColumnPOS
Indexes
Index Type Uniqueness Tablespace Column
REPCAT$_GROUPED_COLUMN_PK NORMAL UNIQUE TablespaceSYSTEM ColumnSNAME
ColumnONAME
ColumnGROUP_NAME
ColumnCOLUMN_NAME
ColumnPOS
REPCAT$_GROUPED_COLUMN_F1_IDX NORMAL NONUNIQUE TablespaceSYSTEM ColumnSNAME
ColumnONAME
ColumnGROUP_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
REPCAT$_GROUPED_COLUMN REPCAT$_GROUPED_COLUMN_F1 TableREPCAT$_COLUMN_GROUP REPCAT$_GROUPED_COLUMN SNAME
REPCAT$_GROUPED_COLUMN ONAME
REPCAT$_GROUPED_COLUMN GROUP_NAME
Columns
Name Datatype Length Mandatory Comments
SNAME VARCHAR2 (128) Yes Owner of replicated object
ONAME VARCHAR2 (128) Yes Name of the replicated object
GROUP_NAME VARCHAR2 (30) Yes Name of the column group
COLUMN_NAME VARCHAR2 (128) Yes Name of the column in the column group
POS NUMBER
Yes Position of a column or an attribute in the table
Query Text

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


SELECT SNAME
,      ONAME
,      GROUP_NAME
,      COLUMN_NAME
,      POS
FROM SYSTEM.REPCAT$_GROUPED_COLUMN;

Dependencies

[top of page]

SYSTEM.REPCAT$_GROUPED_COLUMN does not reference any database object

SYSTEM.REPCAT$_GROUPED_COLUMN is referenced by following:

SchemaSYS
ViewDBA_REPGROUPED_COLUMN
Package BodyDBMS_DEFERGEN_AUDIT - show dependent code
Package BodyDBMS_DEFERGEN_RESOLUTION - show dependent code
Package BodyDBMS_MAINT_GEN - show dependent code
Package BodyDBMS_OFFLINE_RGT_INTERNAL - show dependent code
Package BodyDBMS_REPCAT_CONF - show dependent code
Package BodyDBMS_REPCAT_FLA - show dependent code
Package BodyDBMS_REPCAT_FLA_MAS - show dependent code
Package BodyDBMS_REPCAT_MIG_INTERNAL - show dependent code
Package BodyDBMS_REPCAT_UTL - show dependent code
View_ALL_REPGROUPED_COLUMN