设为首页 加入收藏

TOP

导出报错:ORA-04063: package body “DMSYS.DBMS_DM_MODEL_EXP” has errors
2015-11-10 12:16:18 来源: 作者: 【 】 浏览:0
Tags:导出 ORA-04063: package body DMSYS.DBMS_DM_MODEL_EXP has errors

因为是升级的数据库系统, 保留了 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了


】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇impdp报错ORA-39001、ORA-39000、.. 下一篇Ubuntu 15.04下MySQL 5.6.25不支..

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: