Check the OLAP option is enabled in database.

select parameter, value from v$option where parameter = ‘OLAP’;

PARAMETER VALUE
OLAP  FALSE

select comp_id, comp_name, version, status, schema from dba_registry where comp_name like ‘%OLAP%’;

COMP_ID COMP_NAME VERSION STATUS SCHEMA
APS OLAP Analytic Workspace 19.0.0.0.0 OPTION OFF SYS
XOQ Oracle OLAP API 19.0.0.0.0 OPTION OFF OLAPSYS

OLAP option is FALSE and no OLAP usage in the database.

OLAP can be removed from the database.

The next step is to check whether we have OLAP data that we need to check into before the removal.

For this please run the following query as SYS

select owner,aw_name from dba_aws where owner !=’SYS’

no rows selected

The next step is to run the scripts that remove the Oracle OLAP option

SQL> conn / as sysdba
SQL> spool remove_olap.log
—-> Remove OLAP Catalog
SQL> @?/olap/admin/catnoamd.sql
—-> Remove OLAP API
SQL> @?/olap/admin/catnoxoq.sql
—-> Deinstall APS – OLAP AW component
SQL> @?/olap/admin/catnoaps.sql
—-> Recompile invalids
SQL> @?/rdbms/admin/utlrp.sql

Now the Oracle OLAP option has been removed from the database.

Share this post
Recommended Posts

Leave a Comment

Start typing and press Enter to search