olap api

How to remove the Oracle OLAP Option from a 12c Database during 19c Upgrade

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…

Read More

Steps to remove OLAP API and OLAP Catalog

1. Remove Oracle OLAP API: *************************** @?/olap/admin/olapidrp.plb @?/olap/admin/catnoxoq.sql @?/rdbms/admin/utlrp.sql select comp_id, comp_name, version, status from dba_registry where COMP_ID=’XOQ’; SELECT object_name,object_type,owner FROM dba_objects WHERE status = ‘INVALID’; alter public synonym DBMS_CUBE_ADVISE…

Read More