Skip to main content

DATAPUMP IMPORT HANGS AT INDEXES

Image
By
  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.

 

Comments

Post a Comment

Popular posts from this blog

OBIEE 11g Error "Selected item is not of valid selection type" In Agent When Select Dashboard Page For Content

By
OBIEE 11g Error"Selected item is not of valid selection type" This error applies to OBIEE - version 11.1.1.7.0 and later . When you try to choose a dashboard page for delivery content in an agent, it constantly fails with the error message " Selected item is not of valid selection type ”.  Solution: This error may happen, when there is an added extra space after the end of the name of the dashboard page. For example, instead of "PAGE", it is "PAGE   "  It may happen with a space at the beginning of the name also. Removal of the extra space by renaming the dashboard page will correct the error.
9 comments
Read more

Setting User Defined JVM Memory Arguments in JDeveloper 11g Integrated WebLogic Server

By
Setting User Defined JVM Memory Arguments in JDeveloper 11g Integrated WebLogic Server This guide explains how to set your own predefined JVM memory arguments for the JDeveloper WebLogic container at startup for the integrated WebLogic server.   This will help avoid java.lang.OutOfMemoryError s experienced on heavy java processes and also improve on the integrated JDeveloper WebLogic server’s performance overall. Steps Locate the file: setDomainEnv.cmd which should be at: [JDeveloper Working Directory]\jdeveloper\system.xxx.xx.xx\DefaultDomain\bin                                 i.             Note: [JDeveloper Working Directory] will be "C:\Documents and Settings\<username>\Application...
3 comments
Read more