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

TABLE: DVSYS.COMMAND_RULE$

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: COMMAND_RULE$_PK1
  1. ColumnID#
Unique Key: COMMAND_RULE$_UK1
  1. ColumnCODE_ID#
  2. ColumnOBJECT_OWNER_UID#
  3. ColumnOBJECT_NAME
Indexes
Index Type Uniqueness Tablespace Column
COMMAND_RULE$_PK1 NORMAL UNIQUE TablespaceSYSAUX ColumnID#
COMMAND_RULE$_UK1 NORMAL UNIQUE TablespaceSYSAUX ColumnCODE_ID#
ColumnOBJECT_OWNER_UID#
ColumnOBJECT_NAME
COMMAND_RULE$_FK1_IDX NORMAL NONUNIQUE TablespaceSYSAUX ColumnCODE_ID#
COMMAND_RULE$_FK_IDX NORMAL NONUNIQUE TablespaceSYSAUX ColumnRULE_SET_ID#
Foreign Keys
Table
Foreign Table Foreign Key Column
COMMAND_RULE$ COMMAND_RULE$_FK1 TableCODE$ COMMAND_RULE$ CODE_ID#
COMMAND_RULE$ COMMAND_RULE$_FK TableRULE_SET$ COMMAND_RULE$ RULE_SET_ID#
Columns
Name Datatype Length Mandatory Comments
ID# NUMBER
Yes
CODE_ID# NUMBER
Yes
RULE_SET_ID# NUMBER
Yes
OBJECT_OWNER VARCHAR2 (128)
OBJECT_OWNER_UID# NUMBER
Yes
OBJECT_NAME VARCHAR2 (128) Yes
ENABLED VARCHAR2 (1) Yes
PRIVILEGE_SCOPE NUMBER

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#
,      CODE_ID#
,      RULE_SET_ID#
,      OBJECT_OWNER
,      OBJECT_OWNER_UID#
,      OBJECT_NAME
,      ENABLED
,      PRIVILEGE_SCOPE
,      VERSION
,      CREATED_BY
,      CREATE_DATE
,      UPDATED_BY
,      UPDATE_DATE
FROM DVSYS.COMMAND_RULE$;

Dependencies

[top of page]

DVSYS.COMMAND_RULE$ does not reference any database object

DVSYS.COMMAND_RULE$ is referenced by following:

SchemaDVSYS
ViewDBA_DV_COMMAND_RULE
ViewDV$COMMAND_RULE