[Home] [Help] [Dependency Information]
Object Name: | DBMS_PARALLEL_EXECUTE_TASK$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PK_DBMS_PARALLEL_EXECUTE_1 | NORMAL | UNIQUE | SYSTEM |
TASK_OWNER#
TASK_NAME |
SYS_IL0000498771C00011$$ | LOB | UNIQUE | SYSTEM |
Table | |
Foreign Table | Foreign Key Column | DBMS_PARALLEL_EXECUTE_CHUNKS$ | DBMS_PARALLEL_EXECUTE_TASK$ |
DBMS_PARALLEL_EXECUTE_CHUNKS$
TASK_OWNER#
DBMS_PARALLEL_EXECUTE_CHUNKS$ TASK_NAME |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_OWNER# | NUMBER | Yes | ||
TASK_NAME | VARCHAR2 | (128) | Yes | |
CHUNK_TYPE | NUMBER | Yes | ||
STATUS | NUMBER | Yes | ||
TABLE_OWNER | VARCHAR2 | (128) | ||
TABLE_NAME | VARCHAR2 | (128) | ||
NUMBER_COLUMN | VARCHAR2 | (128) | ||
CMT | VARCHAR2 | (4000) | ||
JOB_PREFIX | VARCHAR2 | (128) | ||
STOP_FLAG | NUMBER | |||
SQL_STMT | CLOB | (4000) | ||
LANGUAGE_FLAG | NUMBER | |||
EDITION | VARCHAR2 | (130) | ||
APPLY_CROSSEDITION_TRIGGER | VARCHAR2 | (130) | ||
FIRE_APPLY_TRIGGER | VARCHAR2 | (10) | ||
PARALLEL_LEVEL | NUMBER | |||
JOB_CLASS | VARCHAR2 | (128) |
Cut, paste (and edit) the following text to query this object:
SELECT TASK_OWNER#
, TASK_NAME
, CHUNK_TYPE
, STATUS
, TABLE_OWNER
, TABLE_NAME
, NUMBER_COLUMN
, CMT
, JOB_PREFIX
, STOP_FLAG
, SQL_STMT
, LANGUAGE_FLAG
, EDITION
, APPLY_CROSSEDITION_TRIGGER
, FIRE_APPLY_TRIGGER
, PARALLEL_LEVEL
, JOB_CLASS
FROM SYS.DBMS_PARALLEL_EXECUTE_TASK$;
SYS.DBMS_PARALLEL_EXECUTE_TASK$ does not reference any database object
SYS.DBMS_PARALLEL_EXECUTE_TASK$ is referenced by following:
|
|
|