I am tracing impdp with trace=480300. Please see the tail output from the trace file.
It is not moving from here. Master and worker sessions are showing active in the DB.KUPM: 17:36:19.914: ...defaulting parameter REUSE_DATAFILES
KUPM: 17:36:19.914: ...defaulting parameter SKIP_UNUSABLE_INDEXES
KUPM: 17:36:19.915: ...defaulting parameter STREAMS_CONFIGURATION
KUPM: 17:36:19.916: ...defaulting parameter TABLE_CONSISTENCY
KUPM: 17:36:19.916: ...defaulting parameter TABLE_EXISTS_ACTION
KUPM: 17:36:19.917: ...defaulting parameter TTS_FULL_CHECK
KUPM: 17:36:19.918: ...defaulting parameter USER_METADATA
KUPM: 17:36:19.933: Starting worker: 1 using SYS.KUPW$WORKER.MAIN('SYS_IMPORT_SCHEMA_02', 'SYSTEM');
KUPM: 17:36:20.017: Worker started.
KUPM: 17:36:20.018: *******OUT DISPATCH , request type=1003 response type =
I appreciate your comments.DATE PROGRAM SID STATUS USERNAME
-------------------- ------------------------------ ---------- -------- ---------------
JOB_NAME SPID SERIAL# PID
------------------------------ ------------ ---------- ----------
2009-09-16 00:00:00 udi@test-t5220 (TNS V1-V3) 508 ACTIVE SYSTEM
SYS_IMPORT_SCHEMA_02 6794 2089 29
2009-09-16 00:00:00 oracle@test-t5220 (DM00) 473 ACTIVE SYSTEM
SYS_IMPORT_SCHEMA_02 6796 662 30
2009-09-16 00:00:00 oracle@test-t5220 (DW01) 423 ACTIVE SYSTEM
SYS_IMPORT_SCHEMA_02 6798
Thanks,




Reply With Quote