viernes, 5 de febrero de 2016

ORACLE EXP ORA-04063: package body "SYS.DBMS_CUBE_EXP" has errors SOLVED

PROBLEM:
Connected to: Oracle Database 12c Release 12.1.0.1.0 - 64bit Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_CUBE_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_CUBE_EXP"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_CUBE_EXP.schema_info_exp


SOLUTION:
The problem apparently are components incorrectly installed.
I solved in my developer database, if you are going to do it in production Isuggest to investigate a little more.

--BACKUP
create table sys.exppkgact$_backup as select * from sys.exppkgact$;
-- DELETE
delete from sys.exppkgact$ where package = 'DBMS_CUBE_EXP' and schema= 'SYS';

No hay comentarios.:

Publicar un comentario