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


TABLE: SYS.DBMS_PARALLEL_EXECUTE_TASK$

Object Details
Object Name: DBMS_PARALLEL_EXECUTE_TASK$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: PK_DBMS_PARALLEL_EXECUTE_1
  1. ColumnTASK_OWNER#
  2. ColumnTASK_NAME
Indexes
Index Type Uniqueness Tablespace Column
PK_DBMS_PARALLEL_EXECUTE_1 NORMAL UNIQUE TablespaceSYSTEM ColumnTASK_OWNER#
ColumnTASK_NAME
SYS_IL0000498771C00011$$ LOB UNIQUE TablespaceSYSTEM
Foreign Keys
Table
Foreign Table Foreign Key Column
TableDBMS_PARALLEL_EXECUTE_CHUNKS$ FK_DBMS_PARALLEL_EXECUTE_1 DBMS_PARALLEL_EXECUTE_TASK$ DBMS_PARALLEL_EXECUTE_CHUNKS$ TASK_OWNER#
DBMS_PARALLEL_EXECUTE_CHUNKS$ TASK_NAME
Columns
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)
Query Text

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$;

Dependencies

[top of page]

SYS.DBMS_PARALLEL_EXECUTE_TASK$ does not reference any database object

SYS.DBMS_PARALLEL_EXECUTE_TASK$ is referenced by following:

SchemaSYS
ViewDBA_PARALLEL_EXECUTE_TASKS
Package BodyDBMS_PARALLEL_EXECUTE - show dependent code
PL/SQL PackageDBMS_PARALLEL_EXECUTE_INTERNAL - show dependent code
Package BodyDBMS_PARALLEL_EXECUTE_INTERNAL - show dependent code
ViewUSER_PARALLEL_EXECUTE_TASKS