Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled

Gary SinghApr 2 2019 — edited Apr 9 2019

Hi,

We downgraded from enterprise to standard edition. when i ran expdp i got this in logs

Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MARKER

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

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE

i tried

SQL> delete from sys.exppkgact$ where package = 'DBMS_AW_EXP' and schema= 'SYS';

0 rows deleted.

how do i remove OLAP?

Thanks

Added on Apr 2 2019

#database-key-features, #export-import-sql-loader-external-tables

2 comments

4,651 views