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

TABLE: SYSTEM.REPCAT$_REPCOLUMN

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

Replicated columns for a table sorted alphabetically in ascending order

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: REPCAT$_REPCOLUMN_PK
  1. ColumnSNAME
  2. ColumnONAME
  3. ColumnTYPE
  4. ColumnCNAME
Indexes
Index Type Uniqueness Tablespace Column
REPCAT$_REPCOLUMN_PK NORMAL UNIQUE TablespaceSYSTEM ColumnSNAME
ColumnONAME
ColumnTYPE
ColumnCNAME
REPCAT$_REPCOLUMN_FK_IDX NORMAL NONUNIQUE TablespaceSYSTEM ColumnSNAME
ColumnONAME
ColumnTYPE
REPCAT$_REPCOLUMN_UK NORMAL NONUNIQUE TablespaceSYSTEM ColumnSNAME
ColumnONAME
ColumnTYPE
ColumnPOS
Foreign Keys
Table
Foreign Table Foreign Key Column
REPCAT$_REPCOLUMN REPCAT$_REPCOLUMN_FK TableREPCAT$_REPOBJECT REPCAT$_REPCOLUMN SNAME
REPCAT$_REPCOLUMN ONAME
REPCAT$_REPCOLUMN 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
CNAME VARCHAR2 (128) Yes Column name
ID NUMBER

Column ID
POS NUMBER

Ordering of column used as IN parameter in the replication procedures
FLAG RAW (2)
Replication information about column
CTYPE NUMBER

Type of the column
LENGTH NUMBER

Length of the column in bytes
PRECISION# NUMBER

Length: decimal digits (NUMBER) or binary digits (FLOAT)
SCALE NUMBER

Digits to right of decimal point in a number
NULL$ NUMBER

Does column allow NULL values?
CHARSETID NUMBER

Character set identifier
CHARSETFORM NUMBER

Character set form
HASHCODE RAW (17)
Hashcode of a column of user-defined type
CLENGTH NUMBER

The maximum length of the column in characters
VERSION# NUMBER

Version# of a column of user-defined type
LCNAME VARCHAR2 (4000)
Long column name
TOID RAW (16)
Type object identifier of a user-defined type
CTYPE_NAME VARCHAR2 (128)
CTYPE_OWNER VARCHAR2 (128)
TOP VARCHAR2 (128)
Top column name for an attribute
PROPERTY RAW (4)
Query Text

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


SELECT SNAME
,      ONAME
,      TYPE
,      CNAME
,      ID
,      POS
,      FLAG
,      CTYPE
,      LENGTH
,      PRECISION#
,      SCALE
,      NULL$
,      CHARSETID
,      CHARSETFORM
,      HASHCODE
,      CLENGTH
,      VERSION#
,      LCNAME
,      TOID
,      CTYPE_NAME
,      CTYPE_OWNER
,      TOP
,      PROPERTY
FROM SYSTEM.REPCAT$_REPCOLUMN;

Dependencies

[top of page]

SYSTEM.REPCAT$_REPCOLUMN does not reference any database object

SYSTEM.REPCAT$_REPCOLUMN is referenced by following:

SchemaSYS
ViewALL_REPPARAMETER_COLUMN
ViewDBA_REPKEY_COLUMNS
ViewDBA_REPPARAMETER_COLUMN
Package BodyDBMS_DEFERGEN - show dependent code
Package BodyDBMS_DEFERGEN_AUDIT - show dependent code
Package BodyDBMS_DEFERGEN_INTERNAL - show dependent code
Package BodyDBMS_DEFERGEN_RESOLUTION - 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_FLA_UTL - show dependent code
Package BodyDBMS_REPCAT_MAS - show dependent code
Package BodyDBMS_REPCAT_MIG_INTERNAL - show dependent code
Package BodyDBMS_REPCAT_OBJ_UTL - show dependent code
Package BodyDBMS_REPCAT_RGT_CUST - show dependent code
Package BodyDBMS_REPCAT_RQ - show dependent code
Package BodyDBMS_REPCAT_UTL - show dependent code
Package BodyDBMS_REPCAT_UTL3 - show dependent code
ViewREPCAT_REPCOLUMN_BASE
ViewREPCAT_REPFLAVOR_COLUMNS
ViewUSER_REPPARAMETER_COLUMN
View_ALL_REPCOLUMN
View_ALL_REPGROUPED_COLUMN
View_ALL_REPPARAMETER_COLUMN