ORA-04063: package body “SYS.KUPW$WORKER” has errors

Import: Release 10.2.0.5.0 – 64bit Production on Wednesday, 15 October, 2013 21:11:16

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-39006: internal error ORA-39065: unexpected master process exception in DISPATCH ORA-04063: package body “SYS.KUPW$WORKER” has errors ORA-06508: PL/SQL: could not find program unit being called: “SYS.KUPW$WORKER”

ORA-39097: Data Pump job encountered unexpected error -6508

Login as SYS and follow the steps
SQL> CREATE GLOBAL TEMPORARY TABLE sys.ku$noexp_tab ON COMMIT PRESERVE ROWS  AS SELECT * FROM sys.ku_noexp_view;
Table created.
SQL> GRANT SELECT ON sys.ku$noexp_tab TO PUBLIC;
Grant succeeded.
SQL> GRANT INSERT ON sys.ku$noexp_tab TO PUBLIC;
Grant succeeded.
SQL> alter package KUPW$WORKER compile BODY;
Package body altered.

 

Started again import process done successfully

 

Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in Oracle backup & recovery. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s