Skip to content

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

TABLE: SYS.KU$_DATAPUMP_MASTER_11_1_0_7

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

Temporary Table Details

SYS.KU$_DATAPUMP_MASTER_11_1_0_7 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
SYS_IL0000800860C00091$$ LOB UNIQUE TablespaceSYSTEM
Columns
Name Datatype Length Mandatory Comments
ABORT_STEP NUMBER

ANCESTOR_PROCESS_ORDER NUMBER

BASE_OBJECT_NAME VARCHAR2 (30)
BASE_OBJECT_SCHEMA VARCHAR2 (30)
BASE_OBJECT_TYPE VARCHAR2 (30)
BASE_PROCESS_ORDER NUMBER

BLOCK_SIZE NUMBER

CLUSTER_OK NUMBER

COMPLETED_BYTES NUMBER

COMPLETED_ROWS NUMBER

COMPLETION_TIME DATE

CONTROL_QUEUE VARCHAR2 (30)
CREATION_LEVEL NUMBER

CUMULATIVE_TIME NUMBER

DATA_BUFFER_SIZE NUMBER

DATA_IO NUMBER

DB_VERSION VARCHAR2 (60)
DEGREE NUMBER

DOMAIN_PROCESS_ORDER NUMBER

DUMP_ALLOCATION NUMBER

DUMP_FILEID NUMBER

DUMP_LENGTH NUMBER

DUMP_ORIG_LENGTH NUMBER

DUMP_POSITION NUMBER

DUPLICATE NUMBER

ELAPSED_TIME NUMBER

ERROR_COUNT NUMBER

EXTEND_SIZE NUMBER

FILE_MAX_SIZE NUMBER

FILE_NAME VARCHAR2 (4000)
FILE_TYPE NUMBER

FLAGS NUMBER

GRANTOR VARCHAR2 (30)
GRANULES NUMBER

GUID RAW (16)
IN_PROGRESS CHAR (1)
INSTANCE VARCHAR2 (60)
IS_DEFAULT NUMBER

JOB_MODE VARCHAR2 (21)
JOB_VERSION VARCHAR2 (60)
LAST_FILE NUMBER

LAST_UPDATE DATE

LOAD_METHOD NUMBER

METADATA_BUFFER_SIZE NUMBER

METADATA_IO NUMBER

NAME VARCHAR2 (30)
OBJECT_LONG_NAME VARCHAR2 (4000)
OBJECT_NAME VARCHAR2 (200)
OBJECT_NUMBER NUMBER

OBJECT_PATH_SEQNO NUMBER

OBJECT_ROW NUMBER

OBJECT_SCHEMA VARCHAR2 (30)
OBJECT_TABLESPACE VARCHAR2 (30)
OBJECT_TYPE VARCHAR2 (30)
OBJECT_TYPE_PATH VARCHAR2 (200)
OLD_VALUE VARCHAR2 (4000)
OPERATION VARCHAR2 (8)
ORIGINAL_OBJECT_NAME VARCHAR2 (128)
ORIGINAL_OBJECT_SCHEMA VARCHAR2 (30)
PACKET_NUMBER NUMBER

PARALLELIZATION NUMBER

PARENT_PROCESS_ORDER NUMBER

PARTITION_NAME VARCHAR2 (30)
PHASE NUMBER

PLATFORM VARCHAR2 (101)
PROCESS_NAME VARCHAR2 (30)
PROCESS_ORDER NUMBER

PROCESSING_STATE CHAR (1)
PROCESSING_STATUS CHAR (1)
PROPERTY NUMBER

SCN NUMBER

SEED NUMBER

SERVICE_NAME VARCHAR2 (64)
SIZE_ESTIMATE NUMBER

START_TIME DATE

STATE VARCHAR2 (12)
STATUS_QUEUE VARCHAR2 (30)
SUBPARTITION_NAME VARCHAR2 (30)
TIMEZONE VARCHAR2 (64)
TOTAL_BYTES NUMBER

TRIGFLAG NUMBER

UNLOAD_METHOD NUMBER

USER_DIRECTORY VARCHAR2 (4000)
USER_FILE_NAME VARCHAR2 (4000)
USER_NAME VARCHAR2 (30)
VALUE_N NUMBER

VALUE_T VARCHAR2 (4000)
VERSION NUMBER

WORK_ITEM VARCHAR2 (21)
XML_CLOB CLOB (4000)
Query Text

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


SELECT ABORT_STEP
,      ANCESTOR_PROCESS_ORDER
,      BASE_OBJECT_NAME
,      BASE_OBJECT_SCHEMA
,      BASE_OBJECT_TYPE
,      BASE_PROCESS_ORDER
,      BLOCK_SIZE
,      CLUSTER_OK
,      COMPLETED_BYTES
,      COMPLETED_ROWS
,      COMPLETION_TIME
,      CONTROL_QUEUE
,      CREATION_LEVEL
,      CUMULATIVE_TIME
,      DATA_BUFFER_SIZE
,      DATA_IO
,      DB_VERSION
,      DEGREE
,      DOMAIN_PROCESS_ORDER
,      DUMP_ALLOCATION
,      DUMP_FILEID
,      DUMP_LENGTH
,      DUMP_ORIG_LENGTH
,      DUMP_POSITION
,      DUPLICATE
,      ELAPSED_TIME
,      ERROR_COUNT
,      EXTEND_SIZE
,      FILE_MAX_SIZE
,      FILE_NAME
,      FILE_TYPE
,      FLAGS
,      GRANTOR
,      GRANULES
,      GUID
,      IN_PROGRESS
,      INSTANCE
,      IS_DEFAULT
,      JOB_MODE
,      JOB_VERSION
,      LAST_FILE
,      LAST_UPDATE
,      LOAD_METHOD
,      METADATA_BUFFER_SIZE
,      METADATA_IO
,      NAME
,      OBJECT_LONG_NAME
,      OBJECT_NAME
,      OBJECT_NUMBER
,      OBJECT_PATH_SEQNO
,      OBJECT_ROW
,      OBJECT_SCHEMA
,      OBJECT_TABLESPACE
,      OBJECT_TYPE
,      OBJECT_TYPE_PATH
,      OLD_VALUE
,      OPERATION
,      ORIGINAL_OBJECT_NAME
,      ORIGINAL_OBJECT_SCHEMA
,      PACKET_NUMBER
,      PARALLELIZATION
,      PARENT_PROCESS_ORDER
,      PARTITION_NAME
,      PHASE
,      PLATFORM
,      PROCESS_NAME
,      PROCESS_ORDER
,      PROCESSING_STATE
,      PROCESSING_STATUS
,      PROPERTY
,      REMOTE_LINK
,      SCN
,      SEED
,      SERVICE_NAME
,      SIZE_ESTIMATE
,      START_TIME
,      STATE
,      STATUS_QUEUE
,      SUBPARTITION_NAME
,      TIMEZONE
,      TOTAL_BYTES
,      TRIGFLAG
,      UNLOAD_METHOD
,      USER_DIRECTORY
,      USER_FILE_NAME
,      USER_NAME
,      VALUE_N
,      VALUE_T
,      VERSION
,      WORK_ITEM
,      XML_CLOB
FROM SYS.KU$_DATAPUMP_MASTER_11_1_0_7;

Dependencies

[top of page]

SYS.KU$_DATAPUMP_MASTER_11_1_0_7 does not reference any database object

SYS.KU$_DATAPUMP_MASTER_11_1_0_7 is not referenced by any database object