I initiated a Datapump Import job at 11am.It took almost 30minutes to load all the tables but 8 hours later, the import log file shows that it's doing " Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX ", so it means the import job has been hanging for almost 7.5 hours. Check dba_resumable view to see when the suspension happened SQL>select user_id,session_id, status, start_time, suspend_time,resume_time, error_msg from dba_resumable; Check the error message. My error message was; ORA-01691: unable to extend lob segment XXXXXXXX by value in tablespace XXX Solution: SQL> alter tablespace XXX add datafile '/YOUR_PATH/XXX02.dbf' size 20M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED; You are good to go.