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

TABLE: SYSTEM.REPCAT$_USER_PARM_VALUES

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: REPCAT$_USER_PARM_VALUES_PK
  1. ColumnUSER_PARAMETER_ID
Unique Key: REPCAT$_USER_PARM_VALUES_U1
  1. ColumnTEMPLATE_PARAMETER_ID
  2. ColumnUSER_ID
Indexes
Index Type Uniqueness Tablespace Column
REPCAT$_USER_PARM_VALUES_PK NORMAL UNIQUE TablespaceSYSTEM ColumnUSER_PARAMETER_ID
REPCAT$_USER_PARM_VALUES_U1 NORMAL UNIQUE TablespaceSYSTEM ColumnTEMPLATE_PARAMETER_ID
ColumnUSER_ID
SYS_IL0000003292C00004$$ LOB UNIQUE TablespaceSYSTEM
Foreign Keys
Table
Foreign Table Foreign Key Column
REPCAT$_USER_PARM_VALUES REPCAT$_USER_PARM_VALUES_FK1 TableREPCAT$_TEMPLATE_PARMS REPCAT$_USER_PARM_VALUES TEMPLATE_PARAMETER_ID
Columns
Name Datatype Length Mandatory Comments
USER_PARAMETER_ID NUMBER
Yes Internal primary key of the REPCAT$_USER_PARM_VALUES table.
TEMPLATE_PARAMETER_ID NUMBER
Yes Internal primary key of the REPCAT$_TEMPLATE_PARMS table.
USER_ID NUMBER
Yes Database user id.
PARM_VALUE CLOB (4000)
Value of the parameter for this user.
Query Text

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


SELECT USER_PARAMETER_ID
,      TEMPLATE_PARAMETER_ID
,      USER_ID
,      PARM_VALUE
FROM SYSTEM.REPCAT$_USER_PARM_VALUES;

Dependencies

[top of page]

SYSTEM.REPCAT$_USER_PARM_VALUES does not reference any database object

SYSTEM.REPCAT$_USER_PARM_VALUES is referenced by following:

SchemaSYS
ViewALL_REPCAT_USER_PARM_VALUES
ViewDBA_REPCAT_USER_PARM_VALUES
Package BodyDBMS_REPCAT_RGT_ALT - show dependent code
Package BodyDBMS_REPCAT_RGT_CHK - show dependent code
Package BodyDBMS_REPCAT_RGT_CUST - show dependent code
Package BodyDBMS_REPCAT_RGT_UTL - show dependent code
ViewUSER_REPCAT_USER_PARM_VALUES