Database Utilities (MOSC)

MOSC Banner

data pump import full error

edited Oct 8, 2009 2:48AM in Database Utilities (MOSC) 10 commentsAnswered ✓
 Hi,

I created a new test server database (Oracle 11g on Redhat Linux). When I use data pump and try to imp the full database. I got the following error. It seems the SYS.KUPW$WORKER package body is invalid. I tried recompiling but it's still invalid. Should I copy the package from other database?

    

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-04063: package body "SYS.KUPW$WORKER" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.KUPW$WORKER"

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