오라클 11.2.0.4.0 에서 export dump 중 OLAP not enabled 에러 발생 시

오라클 11.2.0.4.0 버전에서 export dump 수행 시 아래와 같은 에러가 발생할 경우 조치 방법

1. 에러

>>> 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

2. 삭제 방법

SQL> DROP PUBLIC SYNONYM OLAPFACTVIEW; 

SQL> DROP PUBLIC SYNONYM OLAPDIMVIEW;

SQL> DROP PUBLIC SYNONYM DBMS_ODM;

SQL> DELETE FROM SYS.EXPPKGACT$ WHERE PACKAGE = 'DBMS_AW_EXP'  AND SCHEMA= 'SYS';

SQL> COMMIT;