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


TABLE: SYS.RULE_SET_IOT$

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

Storage Details
Tablespace: Tablespace
PCT Free: 0
PCT Used: 0
Primary Key: SYS_IOT_TOP_364096
  1. ColumnRS_OBJ#
  2. ColumnEC_OBJ#
  3. ColumnBOX_ID
  4. ColumnVALUE
  5. ColumnRULE_ID
  6. ColumnRULE_OR_PIECE
  7. ColumnROP_ID
Indexes
Index Type Uniqueness Tablespace Column
SYS_IOT_TOP_364096 IOT - TOP UNIQUE TablespaceSYSAUX ColumnRS_OBJ#
ColumnEC_OBJ#
ColumnBOX_ID
ColumnVALUE
ColumnRULE_ID
ColumnRULE_OR_PIECE
ColumnROP_ID
I_RULE_SET_IOT NORMAL NONUNIQUE TablespaceSYSAUX ColumnRS_OBJ#
ColumnEC_OBJ#
ColumnRULE_ID
ColumnRULE_OR_PIECE
ColumnROP_ID
Columns
Name Datatype Length Mandatory Comments
RS_OBJ# NUMBER
Yes
EC_OBJ# NUMBER
Yes
BOX_ID NUMBER
Yes
VALUE RAW (300) Yes
RULE_ID NUMBER
Yes
RULE_OR_PIECE NUMBER
Yes
ROP_ID NUMBER
Yes
Query Text

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


SELECT RS_OBJ#
,      EC_OBJ#
,      BOX_ID
,      VALUE
,      RULE_ID
,      RULE_OR_PIECE
,      ROP_ID
FROM SYS.RULE_SET_IOT$;

Dependencies

[top of page]

SYS.RULE_SET_IOT$ does not reference any database object

SYS.RULE_SET_IOT$ is not referenced by any database object