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