ORA-4063 SYS.DBMS_CUBE_EXP

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12131609/viewspace-1381054/