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

TABLE: ORDSYS.ORDDCM_CT_VLD_MSG

Object Details
Object Name: ORDDCM_CT_VLD_MSG
Object Type: TABLE
Owner: ORDSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Unique Key: ORDDCM_CT_VM_PK
  1. ColumnSOP_INSTANCE_UID
  2. ColumnRULE_NAME
  3. ColumnMSG_TYPE
  4. ColumnMSG_TIME
  5. ColumnUSER_NAME
Indexes
Index Type Uniqueness Tablespace Column
ORDDCM_CT_VM_PK NORMAL UNIQUE TablespaceSYSTEM ColumnSOP_INSTANCE_UID
ColumnRULE_NAME
ColumnMSG_TYPE
ColumnMSG_TIME
ColumnUSER_NAME
Columns
Name Datatype Length Mandatory Comments
SOP_INSTANCE_UID VARCHAR2 (128)
RULE_NAME VARCHAR2 (64) Yes
MESSAGE VARCHAR2 (1999)
MSG_TYPE VARCHAR2 (20) Yes
MSG_TIME TIMESTAMP(6) (11) Yes
USER_NAME VARCHAR2 (64) Yes
Query Text

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


SELECT SOP_INSTANCE_UID
,      RULE_NAME
,      MESSAGE
,      MSG_TYPE
,      MSG_TIME
,      USER_NAME
FROM ORDSYS.ORDDCM_CT_VLD_MSG;

Dependencies

[top of page]

ORDSYS.ORDDCM_CT_VLD_MSG does not reference any database object

ORDSYS.ORDDCM_CT_VLD_MSG is not referenced by any database object