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


TABLE: ODM.ODM_MINING_TASK

Object Details
Object Name: ODM_MINING_TASK
Object Type: TABLE
Owner: ODM
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceODM
PCT Free: 10
PCT Used: 40
Primary Key: MINING_TASK_PK
  1. ColumnID
Unique Key: ODM_MINING_TASK_UK
  1. ColumnNAME
Indexes
Index Type Uniqueness Tablespace Column
MINING_TASK_PK NORMAL UNIQUE TablespaceODM ColumnID
ODM_MINING_TASK_UK NORMAL UNIQUE TablespaceODM ColumnNAME
SYS_IL0000318095C00004$$ LOB UNIQUE TablespaceODM
Foreign Keys
Table
Foreign Table Foreign Key Column
TableODM_MINING_TASK_STATE MINING_TASK_STATE_FK ODM_MINING_TASK ODM_MINING_TASK_STATE ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER (13) Yes
NAME VARCHAR2 (64) Yes
TYPE VARCHAR2 (30) Yes
SERIALIZED_OBJECT BLOB (4000)
CLEAN_FLAG NUMBER (1)
INSTANCE VARCHAR2 (16)
JOB_ID NUMBER

Query Text

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


SELECT ID
,      NAME
,      TYPE
,      SERIALIZED_OBJECT
,      CLEAN_FLAG
,      INSTANCE
,      JOB_ID
FROM ODM.ODM_MINING_TASK;

Dependencies

[top of page]

ODM.ODM_MINING_TASK does not reference any database object

ODM.ODM_MINING_TASK is not referenced by any database object