When doing export (expdp) of 11.2.0.40 Standard Edition database for the upgrade to 12C (12.2.0.1.0) - 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
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'; (Doc ID 1353491.1)
Question: can we just ignore those errors when we export/import and do not do delete rows in current production database ?