if you face an error like the following:
ORA-04063: package body “SYS.DBMS_DATAPUMP” has errors
ORA-06508: PL/SQL: could not find program unit being called: “SYS.DBMS_DATAPUMP”
ORA-06512: at line 6
Solution:
SQL> select comp_id, comp_name, version, status from dba_registry;
if, there are invalid components then use utilrp to recompile all objects within your database:
SQL> @?/rdbms/admin/utlrp.sql
//——— another way is to manually check what is the problem:
SQL> alter package SYS.DBMS_DATAPUMP compile body;
SQL> show errors
** if the previous command doesn’t list the errors you can use the following query:
SQL> select * from dba_errors where OWNER=’SYS’ and NAME=’DBMS_DATAPUMP’;
Hope this helps……
Cheers !