FYI:
Data Pump import and export job use queues, streams and java objects.
If we see any job component is invalid (e.g. dbms_java, queue dictionary scripts not run, rdbms/admin/utlrp.sql not run) we may see the ORA-31623 error.
The ORA-31623 can also happens if you are not current with patches (running catupgrd.sql and/or catpatch.sql ), see MOSC for details.
To troubleshoot the ORA-31623 error, look for entries in dba_registry where “status=”invalid” and check dba_objects for object that are granted owned by SYS that are invalid.
原文:http://blog.csdn.net/a49688448/article/details/18741211