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

TABLE: DVSYS.RULE_SET$

Object Details
Object Name: RULE_SET$
Object Type: TABLE
Owner: DVSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: RULE_SET$_PK1
  1. ColumnID#
Indexes
Index Type Uniqueness Tablespace Column
RULE_SET$_PK1 NORMAL UNIQUE TablespaceSYSAUX ColumnID#
Foreign Keys
Table
Foreign Table Foreign Key Column
TableCOMMAND_RULE$ COMMAND_RULE$_FK RULE_SET$ COMMAND_RULE$ RULE_SET_ID#
TableFACTOR$ FACTOR$_FK1 RULE_SET$ FACTOR$ ASSIGN_RULE_SET_ID#
TableREALM_AUTH$ REALM_AUTH$_FK1 RULE_SET$ REALM_AUTH$ AUTH_RULE_SET_ID#
TableROLE$ ROLE$_FK RULE_SET$ ROLE$ RULE_SET_ID#
TableRULE_SET_RULE$ RULE_SET_RULE$_FK RULE_SET$ RULE_SET_RULE$ RULE_SET_ID#
Columns
Name Datatype Length Mandatory Comments
ID# NUMBER
Yes
ENABLED VARCHAR2 (1) Yes
EVAL_OPTIONS NUMBER
Yes
AUDIT_OPTIONS NUMBER
Yes
FAIL_OPTIONS NUMBER
Yes
FAIL_CODE VARCHAR2 (10)
HANDLER_OPTIONS NUMBER
Yes
HANDLER VARCHAR2 (1024)
VERSION NUMBER

CREATED_BY VARCHAR2 (128)
CREATE_DATE DATE

UPDATED_BY VARCHAR2 (128)
UPDATE_DATE DATE

Query Text

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


SELECT ID#
,      ENABLED
,      EVAL_OPTIONS
,      AUDIT_OPTIONS
,      FAIL_OPTIONS
,      FAIL_CODE
,      HANDLER_OPTIONS
,      HANDLER
,      VERSION
,      CREATED_BY
,      CREATE_DATE
,      UPDATED_BY
,      UPDATE_DATE
FROM DVSYS.RULE_SET$;

Dependencies

[top of page]

DVSYS.RULE_SET$ does not reference any database object

DVSYS.RULE_SET$ is referenced by following:

SchemaDVSYS
ViewDBA_DV_RULE_SET
Package BodyDBMS_MACADM - show dependent code
ViewDV$RULE_SET
ViewKU$_DV_REALM_AUTH_VIEW
ViewKU$_DV_ROLE_VIEW
ViewKU$_DV_RULE_SET_MEMBER_VIEW
ViewKU$_DV_RULE_SET_VIEW