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


TABLE: SYSTEM.REPCAT$_PRIORITY

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

Values and their corresponding priorities in all priority groups in the database

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: REPCAT$_PRIORITY_PK
  1. ColumnSNAME
  2. ColumnPRIORITY_GROUP
  3. ColumnPRIORITY
Indexes
Index Type Uniqueness Tablespace Column
REPCAT$_PRIORITY_PK NORMAL UNIQUE TablespaceSYSTEM ColumnSNAME
ColumnPRIORITY_GROUP
ColumnPRIORITY
REPCAT$_PRIORITY_F1_IDX NORMAL NONUNIQUE TablespaceSYSTEM ColumnPRIORITY_GROUP
ColumnSNAME
Foreign Keys
Table
Foreign Table Foreign Key Column
REPCAT$_PRIORITY REPCAT$_PRIORITY_F1 TableREPCAT$_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
PRIORITY NUMBER
Yes Priority of the value
RAW_VALUE RAW (2000)
Raw value
CHAR_VALUE CHAR (255)
Blank-padded character string
NUMBER_VALUE NUMBER

Numeric value
DATE_VALUE DATE

Date value
VARCHAR2_VALUE VARCHAR2 (4000)
Character string
NCHAR_VALUE NCHAR (1000)
NCHAR string
NVARCHAR2_VALUE NVARCHAR2 (2000)
NVARCHAR2 string
LARGE_CHAR_VALUE CHAR (2000)
Blank-padded character string over 255 characters
Query Text

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


SELECT SNAME
,      PRIORITY_GROUP
,      PRIORITY
,      RAW_VALUE
,      CHAR_VALUE
,      NUMBER_VALUE
,      DATE_VALUE
,      VARCHAR2_VALUE
,      NCHAR_VALUE
,      NVARCHAR2_VALUE
,      LARGE_CHAR_VALUE
FROM SYSTEM.REPCAT$_PRIORITY;

Dependencies

[top of page]

SYSTEM.REPCAT$_PRIORITY does not reference any database object

SYSTEM.REPCAT$_PRIORITY is referenced by following:

SchemaSYS
ViewALL_REPPRIORITY
ViewDBA_REPPRIORITY
Package BodyDBMS_OFFLINE_RGT_INTERNAL - show dependent code
Package BodyDBMS_REPCAT_CONF - show dependent code
Package BodyDBMS_REPCAT_UTL - show dependent code
ViewUSER_REPPRIORITY