在测试环境中，Oracle 数据泵导出时遇到04063等错误，通过检查和手动编译DBMS_METADATA包发现问题。解决方案包括尝试编译该包，以及执行shutdown immediate、startup upgrade、相关脚本和utlrp.sql来修复数据库对象。
测试环境数据泵备份突然报这莫名其妙的错误，怎么引发的原因不详，只能见招拆招先解决问题了。
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
Starting "SYS"."SYS_EXPORT_SCHEMA_04": "/******** AS SYSDBA" ESTIMATE_ONLY=y schemas=GAMEX1125 ESTIMATE=statistics
Estimate in progress using STATISTICS method...
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD [ESTIMATE_PHASE]
ORA-04063: package body "SYS.DBMS_METADATA" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_METADATA"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001
----- PL/SQL Call Stack -----
最低0.47元/天 解锁文章
4628
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
