[Home] [Help] [Dependency Information]

TABLE: ORDSYS.ORDDCM_DOCS

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: ORDDCM_DOCS_PK

1. DOC_ID

Unique Key: ORDDCM_DOCS_UK1

1. DOC_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
ORDDCM_DOCS_PK	NORMAL	UNIQUE	SYSTEM	DOC_ID
ORDDCM_DOCS_UK1	NORMAL	UNIQUE	SYSTEM	DOC_NAME
SYS_IL0000488015C00005$$	LOB	UNIQUE	SYSTEM

Foreign Keys

Table		Foreign Table	Foreign Key Column
ORDDCM_DOCS		ORDDCM_DOC_TYPES	ORDDCM_DOCS DOC_TYPE_ID
ORDDCM_ANON_ATTRS		ORDDCM_DOCS	ORDDCM_ANON_ATTRS DOC_ID
ORDDCM_ANON_RULES		ORDDCM_DOCS	ORDDCM_ANON_RULES DOC_ID
ORDDCM_CT_DAREFS		ORDDCM_DOCS	ORDDCM_CT_DAREFS DOC_ID
ORDDCM_DOC_REFS		ORDDCM_DOCS	ORDDCM_DOC_REFS DOC_ID
ORDDCM_DOC_REFS		ORDDCM_DOCS	ORDDCM_DOC_REFS REF_BY_DOC_ID
ORDDCM_DOC_REFS		ORDDCM_DOCS	ORDDCM_DOC_REFS DOC_NAME
ORDDCM_DOC_REFS		ORDDCM_DOCS	ORDDCM_DOC_REFS REF_BY_DOC_NAME
ORDDCM_MAPPING_DOCS		ORDDCM_DOCS	ORDDCM_MAPPING_DOCS DOC_ID
ORDDCM_PRV_ATTRS		ORDDCM_DOCS	ORDDCM_PRV_ATTRS DOC_ID
ORDDCM_RT_PREF_PARAMS		ORDDCM_DOCS	ORDDCM_RT_PREF_PARAMS DOC_ID
ORDDCM_STD_ATTRS		ORDDCM_DOCS	ORDDCM_STD_ATTRS DOC_ID
ORDDCM_UID_DEFS		ORDDCM_DOCS	ORDDCM_UID_DEFS DOC_ID

Columns

Query Text

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

SELECT DOC_ID
,      DOC_NAME
,      DOC_TYPE_ID
,      DOC_CONTENT
,      ORACLE_INSTALL
,      CREATE_DATE
FROM ORDSYS.ORDDCM_DOCS;

Dependencies

[top of page]

SYS

STANDARD - show dependent code

XMLTYPE

ORDSYS.ORDDCM_DOCS is not referenced by any database object