导出报错：ORA-04063: package body “DMSYS.DBMS_DM_MODEL_EXP” has errors

Oracle 11.2.0.2 , EBS R12.1.3 因为是升级的数据库系统，保留了 DMSYS data mining 组件，但是在库中处于INVALID 状态，查询 dba_registry 可以看到。导出metadata 时报错：
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 1282
ORA-04063: package body "DMSYS.DBMS_DM_MODEL_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "DMSYS.DBMS_DM_MODEL_EXP"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8398处理方法：
SQL> drop user DMSYS;
SQL> DELETE FROM SYS.EXPPKGACT$ WHERE SCHEMA = "DMSYS";
SQL> SELECT COUNT（*） FROM DBA_SYNONYMS WHERE TABLE_OWNER = "DMSYS";

SQL> SET HEAD OFF
SQL> SPOOL /DROP_DMSYS_SYNONYMS.SQL
SQL> SELECT "Drop public synonym " || SYNONYM_NAME || " ;"
FROM DBA_SYNONYMS WHERE TABLE_OWNER = "DMSYS";
SQL> SPOOL OFF
SQL> @/DROP_DMSYS_SYNONYMS.SQL
SQL> EXIT;已经不用dmsys了Oracle升级出现ORA-04063 DBMS_REGISTRY has error http://www.linuxidc.com/Linux/2014-06/103873.htmLinux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm在CentOS 6.4下安装Oracle 11gR2（x64） http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12impdp报错ORA-39001、ORA-39000、ORA-31619Ubuntu 15.04下MySQL 5.6.25不支持中文解决办法相关资讯 ORA-04063

Oracle 数据泵导出报错ORA-39126、（今 09:13）

Oracle升级出现ORA-04063 DBMS_ （06/30/2014 08:38:42）

本文评论查看全部评论（0）