Database Utilities (MOSC)

MOSC Banner

Data pump import hangs in RAC

edited Jan 13, 2011 5:27PM in Database Utilities (MOSC) 9 commentsAnswered
 Hi,

Import data pump hangs for a couple days and never completed. I have to do a schema refresh periodically and was able to complete the import using the REMAP_SCHEMA about 5 times with no problem.

I am using the same export dmp files (4 dmp files) and the same parfile (except the log file date changed), but now my import just hangs at the same point: 

Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM

When I checked processes "ps -ef | grep impdb" I can see the process is running.

When checked "select JOB_NAME,JOB_MODE,STATE,OPERATION from dba_datapump_jobs;" I see my import in status "EXECUTING"  even it hangs a couple of days.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center