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

TABLE: SYS.RULE_SET_ROP$

Object Details
Object Name: RULE_SET_ROP$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: Tablespace
PCT Free: 0
PCT Used: 0
Primary Key: SYS_IOT_TOP_1098152
  1. ColumnRS_OBJ#
  2. ColumnEC_OBJ#
  3. ColumnRULE_ID
  4. ColumnRULE_OR_PIECE
  5. ColumnROP_ID
  6. ColumnPAROP_ID
  7. ColumnAROP_ID
  8. ColumnEVAL_ID
Indexes
Index Type Uniqueness Tablespace Column
SYS_IOT_TOP_1098152 IOT - TOP UNIQUE TablespaceSYSAUX ColumnRS_OBJ#
ColumnEC_OBJ#
ColumnRULE_ID
ColumnRULE_OR_PIECE
ColumnROP_ID
ColumnPAROP_ID
ColumnAROP_ID
ColumnEVAL_ID
Columns
Name Datatype Length Mandatory Comments
RS_OBJ# NUMBER
Yes
EC_OBJ# NUMBER
Yes
RULE_ID NUMBER
Yes
RULE_OR_PIECE NUMBER
Yes
ROP_ID NUMBER
Yes
PAROP_ID NUMBER
Yes
AROP_ID NUMBER
Yes
EVAL_ID NUMBER
Yes
BOX_ID NUMBER

USESFP NUMBER

NOPSFP NUMBER

VARSFP RAW (2000)
PRNUM NUMBER

Query Text

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


SELECT RS_OBJ#
,      EC_OBJ#
,      RULE_ID
,      RULE_OR_PIECE
,      ROP_ID
,      PAROP_ID
,      AROP_ID
,      EVAL_ID
,      BOX_ID
,      USESFP
,      NOPSFP
,      VARSFP
,      PRNUM
FROM SYS.RULE_SET_ROP$;

Dependencies

[top of page]

SYS.RULE_SET_ROP$ does not reference any database object

SYS.RULE_SET_ROP$ is not referenced by any database object