ORA-39127: unexpected error from call to export_string :=SYS.DBMS_CUBE_EXP.INSTANCE_EXTENDED_INFO_EX
When doing export (expdp) of 11.2.0.4.0 Standard Edition database for the upgrade to 12C (12.2.0.1.0) -
I am getting multiple errors like this:
ORA-39127:
unexpected error from call to export_string :=SYS.DBMS_CUBE_EXP.INSTANCE_EXTENDED_INFO_EXP('AW$AWCREATE','SYS',1,2,0,'SYS',1,'11.01.00.00.00',newblock)
ORA-06550:
line 1, column 35:
PLS-00302:
component 'INSTANCE_EXTENDED_INFO_EXP' must be declared
ORA-06550:
line 1, column 7:
PL/SQL:
Statement ignored
ORA-06512: at
"SYS.DBMS_METADATA", line 9926
Note:
We do not use OLAP (VALUE=FALSE in V$OPTION where parameter='OLAP' )
It seems ORACLE in general recommends to delete from exppkgact$ where package =
'DBMS_CUBE_EXP' and schema = 'SYS'; (