-
Datapump import job hang
Hi,
I am doing an import with datapump teh job seem to like hang not going anywhere since 10hrs i know for the fact that something is wrong somewhere,
staus of job from dba_datapump_jobs says executing,its trying to create materialized view and it stuck there almost 10hrs now,alert shows no errors too .Here is the output from
Import> status
Job: SYS_IMPORT_FULL_06
Operation: IMPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 360,286,816
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/reorg/GPOGLD/impdp_dir/GPOTGL120070627.DMP
Worker 1 Status:
State: EXECUTING
Object Schema: GPC
Object Name: VENDOR
Object Type: DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW
Worker Parallelism: 1
output from dba_resumable:
SQL> select * from dba_resumable;
USER_ID SESSION_ID INSTANCE_ID COORD_INSTANCE_ID COORD_SESSION_ID STATUS
---------- ---------- ----------- ----------------- ---------------- ---------
TIMEOUT START_TIME SUSPEND_TIME RESUME_TIME
---------- -------------------- -------------------- --------------------
NAME
--------------------------------------------------------------------------------
SQL_TEXT
--------------------------------------------------------------------------------
ERROR_NUMBER
------------
ERROR_PARAMETER1
--------------------------------------------------------------------------------
ERROR_PARAMETER2
--------------------------------------------------------------------------------
ERROR_PARAMETER3
--------------------------------------------------------------------------------
ERROR_PARAMETER4
--------------------------------------------------------------------------------
ERROR_PARAMETER5
--------------------------------------------------------------------------------
ERROR_MSG
--------------------------------------------------------------------------------
0 29 1 NORMAL
USER_ID SESSION_ID INSTANCE_ID COORD_INSTANCE_ID COORD_SESSION_ID STATUS
---------- ---------- ----------- ----------------- ---------------- ---------
TIMEOUT START_TIME SUSPEND_TIME RESUME_TIME
---------- -------------------- -------------------- --------------------
NAME
--------------------------------------------------------------------------------
SQL_TEXT
--------------------------------------------------------------------------------
ERROR_NUMBER
------------
ERROR_PARAMETER1
--------------------------------------------------------------------------------
ERROR_PARAMETER2
--------------------------------------------------------------------------------
ERROR_PARAMETER3
--------------------------------------------------------------------------------
ERROR_PARAMETER4
--------------------------------------------------------------------------------
ERROR_PARAMETER5
--------------------------------------------------------------------------------
ERROR_MSG
--------------------------------------------------------------------------------
7200
Please let me know what is wrong and where.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|