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


TABLE: ORDDATA.ORDDCM_CT_LOCATORPATHS_TMP

Object Details
Object Name: ORDDCM_CT_LOCATORPATHS_TMP
Object Type: TABLE
Owner: ORDDATA
Subobject Name:
Status: VALID

Temporary Table Details

ORDDATA.ORDDCM_CT_LOCATORPATHS_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
ORDDCM_CT_LPT_DID_IDX NORMAL NONUNIQUE Tablespace ColumnDOC_ID
ORDDCM_CT_LPT_PSID_IDX NORMAL NONUNIQUE Tablespace ColumnPSID
Columns
Name Datatype Length Mandatory Comments
DOC_ID NUMBER
Yes
PSID NUMBER
Yes
LOCATOR_PATH VARCHAR2 (1999) Yes
HAS_MACRO_PARAM NUMBER (1) Yes
IS_COVERED NUMBER (1)
Query Text

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


SELECT DOC_ID
,      PSID
,      LOCATOR_PATH
,      HAS_MACRO_PARAM
,      IS_COVERED
FROM ORDDATA.ORDDCM_CT_LOCATORPATHS_TMP;

Dependencies

[top of page]

ORDDATA.ORDDCM_CT_LOCATORPATHS_TMP does not reference any database object

ORDDATA.ORDDCM_CT_LOCATORPATHS_TMP is referenced by following:

SchemaORDDATA
ViewORDDCM_CT_LOCATORPATHS_USR
SchemaORDSYS
Package BodyORD_DICOM_ADMIN_PRV - show dependent code