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


TABLE: DVSYS.MAC_POLICY$

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: MAC_POLICY$_PK1
  1. ColumnID#
Unique Key: MAC_POLICY$_UK1
  1. ColumnPOLICY_ID#
Indexes
Index Type Uniqueness Tablespace Column
MAC_POLICY$_PK1 NORMAL UNIQUE TablespaceSYSAUX ColumnID#
MAC_POLICY$_UK1 NORMAL UNIQUE TablespaceSYSAUX ColumnPOLICY_ID#
MAC_POLICY$_FK_IDX NORMAL NONUNIQUE TablespaceSYSAUX ColumnALGORITHM_CODE_ID#
Foreign Keys
Table
Foreign Table Foreign Key Column
MAC_POLICY$ MAC_POLICY$_FK1 TableCODE$ MAC_POLICY$ ALGORITHM_CODE_ID#
TableMAC_POLICY_FACTOR$ MAC_POLICY_FACTOR$_FK1 MAC_POLICY$ MAC_POLICY_FACTOR$ MAC_POLICY_ID#
Columns
Name Datatype Length Mandatory Comments
ID# NUMBER
Yes
POLICY_ID# NUMBER
Yes
ALGORITHM_CODE_ID# NUMBER
Yes
ERROR_LABEL VARCHAR2 (4000)
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#
,      POLICY_ID#
,      ALGORITHM_CODE_ID#
,      ERROR_LABEL
,      VERSION
,      CREATED_BY
,      CREATE_DATE
,      UPDATED_BY
,      UPDATE_DATE
FROM DVSYS.MAC_POLICY$;

Dependencies

[top of page]

DVSYS.MAC_POLICY$ does not reference any database object

DVSYS.MAC_POLICY$ is referenced by following:

SchemaDVSYS
ViewDBA_DV_MAC_POLICY
ViewDBA_DV_MAC_POLICY_FACTOR
Package BodyDBMS_MACADM - show dependent code
Package BodyDBMS_MACOLS - show dependent code
Package BodyDBMS_MACOLS_SESSION - show dependent code
ViewDV$MAC_POLICY
ViewDV$MAC_POLICY_FACTOR
PL/SQL PackageMAC_POLICY$_PRIV - show dependent code
Package BodyMAC_POLICY$_PRIV - show dependent code