Oracle 12c expdp DBMS_AW_EXP: SYS.AW$: OLAP not enabled

Data Pump


DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled
DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled
DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled
DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled
DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled
DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled
DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled
Segun lo revisado en Oracle Doc ID 1921158.1

Causa
Error raised from DBMS_AW_EXP, which is an OLAP specific object not available on Standard Edition.

SoluciÛn
SQL> select * from sys.exppkgact$ where package = ‘DBMS_AW_EXP’ and schema= ‘SYS’;

  1. Realiza un backup full.
  2. Ejecutar:
    SQL> delete from sys.exppkgact$ where package = ‘DBMS_AW_EXP’ and schema= ‘SYS’;
    SQL> commit;