[Home] [Help]
[Dependency Information]
| Object Name: | RULE_SET_IOT$ |
|---|---|
| Object Type: | TABLE |
| Owner: | SYS |
| Subobject Name: | |
| Status: | VALID |
| Tablespace: | ![]() |
|---|---|
| PCT Free: | 0 |
| PCT Used: | 0 |
RS_OBJ#
EC_OBJ#
BOX_ID
VALUE
RULE_ID
RULE_OR_PIECE
ROP_ID| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| SYS_IOT_TOP_364096 | IOT - TOP | UNIQUE |
SYSAUX
|
RS_OBJ#
EC_OBJ#
BOX_ID
VALUE
RULE_ID
RULE_OR_PIECE
ROP_ID
|
| I_RULE_SET_IOT | NORMAL | NONUNIQUE |
SYSAUX
|
RS_OBJ#
EC_OBJ#
RULE_ID
RULE_OR_PIECE
ROP_ID
|
| 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 |
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$;
SYS.RULE_SET_IOT$ does not reference any database object
SYS.RULE_SET_IOT$ is not referenced by any database object
|
|
|
|