eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: SYS.KU$_DATAPUMP_MASTER_11_2

Object Details

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

Temporary Table Details

SYS.KU$_DATAPUMP_MASTER_11_2 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:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000800857C00095$$	LOB	UNIQUE	SYSTEM

Columns

Name	Datatype	Length
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
DATAOBJ_NUM	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)
INSTANCE_ID	NUMBER
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_INT_OID	VARCHAR2	(32)
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
QUEUE_TABNUM	NUMBER
REMOTE_LINK	VARCHAR2	(128)
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
,      DATAOBJ_NUM
,      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
,      INSTANCE_ID
,      IS_DEFAULT
,      JOB_MODE
,      JOB_VERSION
,      LAST_FILE
,      LAST_UPDATE
,      LOAD_METHOD
,      METADATA_BUFFER_SIZE
,      METADATA_IO
,      NAME
,      OBJECT_INT_OID
,      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
,      QUEUE_TABNUM
,      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_2;

Dependencies

[top of page]

SYS.KU$_DATAPUMP_MASTER_11_2 does not reference any database object

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