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

TABLE: SYS.RULE_SET_PTPDTY$

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

Storage Details
Tablespace: Tablespace
PCT Free: 0
PCT Used: 0
Primary Key: SYS_IOT_TOP_1099599
  1. ColumnRS_OBJ#
  2. ColumnEC_OBJ#
  3. ColumnRULE_ID
  4. ColumnRULE_OR_PIECE
  5. ColumnROP_ID
  6. ColumnAROP_ID
  7. ColumnPTPDTY_ID
Indexes
Index Type Uniqueness Tablespace Column
SYS_IOT_TOP_1099599 IOT - TOP UNIQUE TablespaceSYSAUX ColumnRS_OBJ#
ColumnEC_OBJ#
ColumnRULE_ID
ColumnRULE_OR_PIECE
ColumnROP_ID
ColumnAROP_ID
ColumnPTPDTY_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
AROP_ID NUMBER
Yes
PTPDTY_ID NUMBER
Yes
PTP NUMBER

DTYNUM 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
,      AROP_ID
,      PTPDTY_ID
,      PTP
,      DTYNUM
FROM SYS.RULE_SET_PTPDTY$;

Dependencies

[top of page]

SYS.RULE_SET_PTPDTY$ does not reference any database object

SYS.RULE_SET_PTPDTY$ is not referenced by any database object