Boa tarde Amigos,
Peguei este erro na minha base de dados de testes.
ORA-04063: package body “SYS.KUPW$WORKER” has errors
Import: Release 10.2.0.3.0 – 64bit Production on Friday, 01 July, 2011 15:00:15
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.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
Hoje eu fui importar dados em uma base de testes e me deparei com um erro chato no impdp. Googlei um pouco e achei esse workaround que salvou o meu dia.
Logue com a conta SYS e execute os comando abaixo
SQL> CREATE GLOBAL TEMPORARY TABLE sys.ku$noexp_tab ON COMMIT PRESERVE ROWS
2 AS SELECT * FROM sys.ku_noexp_view
3 /
Table created.
SQL> GRANT SELECT ON sys.ku$noexp_tab TO PUBLIC
2 /
Grant succeeded.
SQL> GRANT INSERT ON sys.ku$noexp_tab TO PUBLIC
2 /
Grant succeeded.
SQL> alter package KUPW$WORKER compile BODY;
Package body altered.
Pronto!!!
Seu datapump vai funcionar de boa novamente!!!
Atenciosamente,
Rodrigo Mufalani