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

Object Details

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

Temporary Table Details

SYS.KU$_EXPDP_IMPDP_MASTER_10_1 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_IL0000491101C00039$$	LOB	UNIQUE	SYSTEM

Columns

Name	Datatype	Length
PROCESS_ORDER	NUMBER
DUPLICATE	NUMBER
DUMP_FILEID	NUMBER
DUMP_POSITION	NUMBER
DUMP_LENGTH	NUMBER
DUMP_ALLOCATION	NUMBER
COMPLETED_ROWS	NUMBER
ERROR_COUNT	NUMBER
ELAPSED_TIME	NUMBER
OBJECT_TYPE_PATH	VARCHAR2	(200)
OBJECT_PATH_SEQNO	NUMBER
OBJECT_TYPE	VARCHAR2	(30)
IN_PROGRESS	CHAR	(1)
OBJECT_NAME	VARCHAR2	(500)
OBJECT_LONG_NAME	VARCHAR2	(4000)
OBJECT_SCHEMA	VARCHAR2	(30)
ORIGINAL_OBJECT_SCHEMA	VARCHAR2	(30)
PARTITION_NAME	VARCHAR2	(30)
SUBPARTITION_NAME	VARCHAR2	(30)
FLAGS	NUMBER
PROPERTY	NUMBER
COMPLETION_TIME	DATE
OBJECT_TABLESPACE	VARCHAR2	(30)
SIZE_ESTIMATE	NUMBER
OBJECT_ROW	NUMBER
PROCESSING_STATE	CHAR	(1)
PROCESSING_STATUS	CHAR	(1)
BASE_PROCESS_ORDER	NUMBER
BASE_OBJECT_TYPE	VARCHAR2	(30)
BASE_OBJECT_NAME	VARCHAR2	(30)
BASE_OBJECT_SCHEMA	VARCHAR2	(30)
ANCESTOR_PROCESS_ORDER	NUMBER
DOMAIN_PROCESS_ORDER	NUMBER
PARALLELIZATION	NUMBER
UNLOAD_METHOD	NUMBER
GRANULES	NUMBER
SCN	NUMBER
GRANTOR	VARCHAR2	(30)
XML_CLOB	CLOB	(4000)
NAME	VARCHAR2	(30)
VALUE_T	VARCHAR2	(4000)
VALUE_N	NUMBER
IS_DEFAULT	NUMBER
FILE_TYPE	NUMBER
USER_DIRECTORY	VARCHAR2	(4000)
USER_FILE_NAME	VARCHAR2	(4000)
FILE_NAME	VARCHAR2	(4000)
EXTEND_SIZE	NUMBER
FILE_MAX_SIZE	NUMBER
PROCESS_NAME	VARCHAR2	(30)
LAST_UPDATE	DATE
WORK_ITEM	VARCHAR2	(30)
OBJECT_NUMBER	NUMBER
COMPLETED_BYTES	NUMBER
TOTAL_BYTES	NUMBER
METADATA_IO	NUMBER
DATA_IO	NUMBER
CUMULATIVE_TIME	NUMBER
PACKET_NUMBER	NUMBER
OLD_VALUE	VARCHAR2	(4000)
SEED	NUMBER
LAST_FILE	NUMBER
USER_NAME	VARCHAR2	(30)
OPERATION	VARCHAR2	(30)
JOB_MODE	VARCHAR2	(30)
CONTROL_QUEUE	VARCHAR2	(30)
STATUS_QUEUE	VARCHAR2	(30)
REMOTE_LINK	VARCHAR2	(4000)
VERSION	NUMBER
DB_VERSION	VARCHAR2	(30)
TIMEZONE	VARCHAR2	(64)
STATE	VARCHAR2	(30)
PHASE	NUMBER
GUID	RAW	(16)
START_TIME	DATE
BLOCK_SIZE	NUMBER
METADATA_BUFFER_SIZE	NUMBER
DATA_BUFFER_SIZE	NUMBER
DEGREE	NUMBER
PLATFORM	VARCHAR2	(101)
ABORT_STEP	NUMBER
INSTANCE	VARCHAR2	(60)

Query Text

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


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

Dependencies

[top of page]

SYS.KU$_EXPDP_IMPDP_MASTER_10_1 does not reference any database object

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