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


TABLE: SYSTEM.REPCAT$_PRIORITY_GROUP

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

Information about all priority groups in the database

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: REPCAT$_PRIORITY_GROUP_PK
  1. ColumnPRIORITY_GROUP
  2. ColumnSNAME
Unique Key: REPCAT$_PRIORITY_GROUP_U1
  1. ColumnSNAME
  2. ColumnPRIORITY_GROUP
  3. ColumnDATA_TYPE_ID
  4. ColumnFIXED_DATA_LENGTH
Indexes
Index Type Uniqueness Tablespace Column
REPCAT$_PRIORITY_GROUP_PK NORMAL UNIQUE TablespaceSYSTEM ColumnPRIORITY_GROUP
ColumnSNAME
REPCAT$_PRIORITY_GROUP_U1 NORMAL UNIQUE TablespaceSYSTEM ColumnSNAME
ColumnPRIORITY_GROUP
ColumnDATA_TYPE_ID
ColumnFIXED_DATA_LENGTH
Foreign Keys
Table
Foreign Table Foreign Key Column
TableREPCAT$_PRIORITY REPCAT$_PRIORITY_F1 REPCAT$_PRIORITY_GROUP REPCAT$_PRIORITY PRIORITY_GROUP
REPCAT$_PRIORITY SNAME
Columns
Name Datatype Length Mandatory Comments
SNAME VARCHAR2 (30) Yes Name of the replicated object group
PRIORITY_GROUP VARCHAR2 (30) Yes Name of the priority group
DATA_TYPE_ID NUMBER
Yes Datatype of the value in the priority group
FIXED_DATA_LENGTH NUMBER

Length of the value in bytes if the datatype is CHAR
PRIORITY_COMMENT VARCHAR2 (80)
Description of the priority group
Query Text

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


SELECT SNAME
,      PRIORITY_GROUP
,      DATA_TYPE_ID
,      FIXED_DATA_LENGTH
,      PRIORITY_COMMENT
FROM SYSTEM.REPCAT$_PRIORITY_GROUP;

Dependencies

[top of page]

SYSTEM.REPCAT$_PRIORITY_GROUP does not reference any database object

SYSTEM.REPCAT$_PRIORITY_GROUP is referenced by following:

SchemaSYS
ViewALL_REPPRIORITY
ViewALL_REPPRIORITY_GROUP
ViewDBA_REPPRIORITY
ViewDBA_REPPRIORITY_GROUP
Package BodyDBMS_DEFERGEN_PRIORITY - show dependent code
Package BodyDBMS_OFFLINE_RGT_INTERNAL - show dependent code
Package BodyDBMS_REPCAT_CONF - show dependent code
Package BodyDBMS_REPCAT_UTL - show dependent code
ViewUSER_REPPRIORITY
ViewUSER_REPPRIORITY_GROUP