ITPub博客

首页 > 数据库 > Oracle > ORA-4063 SYS.DBMS_CUBE_EXP

ORA-4063 SYS.DBMS_CUBE_EXP

原创 Oracle 作者:ttboylb 时间:2014-12-26 15:21:57 0 删除 编辑



ORA-4063 SYS.DBMS_CUBE_EXP


CAUSE

OLAP objects remain existing in data dictionary while OLAP is not installed or was de-installed. Verify with:
connect / as sysdba
SELECT * FROM SYS.EXPPKGACT$ WHERE PACKAGE = 'DBMS_CUBE_EXP';
SOLUTION

Perform the following:
sqlplus / as sysdba

-- backup the table SYS.EXPPKGACT$ before deleting the row
SQL> CREATE TABLE SYS.EXPPKGACT$_BACKUP AS SELECT * FROM SYS.EXPPKGACT$;

-- delete the DBMS_CUBE_EXP from the SYS.EXPPKGACT$
SQL> DELETE FROM SYS.EXPPKGACT$ WHERE PACKAGE = 'DBMS_CUBE_EXP' AND SCHEMA= 'SYS';
SQL> COMMIT;

Run EXPDP command again.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12131609/viewspace-1381054/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 被锁的对象+KILL
请登录后发表评论 登录
全部评论

注册时间:2011-01-07

  • 博文量
    60
  • 访问量
    252007