原 Oracle 19c使用impdp导入数据报错 ORA-39006: internal error 、ORA-39065: unexpected master process exception in DISPATCH、ORA-01001: invalid cursor、ORA-06512: at "SYS.DBMS_METADATA_UTIL", line 3405
👉 本文共约278个字，系统预计阅读时间或需2分钟。
现象
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | -- 导出 Starting "SYS"."SYS_EXPORT_SCHEMA_01": "sys/******** AS SYSDBA" directory=dpdump schemas=ANCUSER dumpfile=ANCUSER_wf.dmp logfile=ANCUSER_wf.log compression=all parallel=4 -- 导入 export ORACLE_SID=ORCLCDB sqlplus / as sysdba create directory d1 as '/opt/19c/'; grant all on directory d1 to public; create user lhr identified by lhr; grant dba to lhr; impdp lhr/lhr DIRECTORY=d1 DUMPFILE=ANCUSER_wf.dmp FULL=Y PARALLEL=2 table_exists_action=REPLACE |
报错：
1 2 3 4 5 6 7 8 | ORA-39006: internal error ORA-39065: unexpected master process exception in DISPATCH ORA-01001: invalid cursor ORA-06512: at "SYS.DBMS_METADATA_UTIL", line 3405 ORA-06512: at "SYS.KUPM$MCP", line 2635 ORA-39097: Data Pump job encountered unexpected error -1001 |
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
