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 compile;
alter public synonym GENOLAPIEXCEPTION compile;
alter public synonym GENINTERFACESTUB compile;
alter public synonym GENINTERFACESTUBSEQUENCE compile;
alter public synonym GENRAWSEQUENCE compile;
alter public synonym GENWSTRINGSEQUENCE compile;
alter public synonym DBMS_CUBE compile;
alter public synonym GENDATABASEINTERFACE compile;
alter public synonym GENCONNECTIONINTERFACE compile;
alter public synonym GENSERVERINTERFACE compile;
alter public synonym GENMDMPROPERTYIDCONSTANTS compile;
alter public synonym GENMDMCLASSCONSTANTS compile;
alter public synonym GENMDMOBJECTIDCONSTANTS compile;
alter public synonym GENMETADATAPROVIDERINTERFACE compile;
alter public synonym GENCURSORMANAGERINTERFACE compile;
alter public synonym GENDATATYPEIDCONSTANTS compile;
alter public synonym GENDEFINITIONMANAGERINTERFACE compile;
alter public synonym GENDATAPROVIDERINTERFACE compile;
alter public synonym DBMS_AW_XML compile;
2. Remove OLAP Catalog:
************************
@?/olap/admin/catnoamd.sql
shutdown immediate;
startup
drop user OLAPSYS cascade;
drop package OLAPSYS.DBMS_AWM_PRV;
drop package OLAPSYS.CWM2_OLAP_UTILITY;
drop package OLAPSYS.CWM2_OLAP_VALIDATE_UTILITY;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_VERIFY_ACCESS;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_CUBE;
drop PACKAGE BODY “OLAPSYS”.DBMS_AWM;
drop PACKAGE BODY “OLAPSYS”.DBMS_AWM_PRV;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_OLAPAPI_ENABLE;
drop PACKAGE BODY “OLAPSYS”.DBMS_ODM;
drop PACKAGE BODY “OLAPSYS”.OLAPDIMVIEW;
drop PACKAGE BODY “OLAPSYS”.OLAPFACTVIEW;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_METADATA_REFRESH;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_MR_SESSION_POP;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_MR_SECURITY_INIT;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_CLASSIFY;
drop PACKAGE BODY “OLAPSYS”.CWM2$SECURITY;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_TABLE_MAP;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_DELETE;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_EXPORT;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_VALIDATE;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_VALIDATE_METADATA;
drop PACKAGE BODY “OLAPSYS”.CWM1_OLAP_VALIDATE_METADATA;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_VALIDATE_UTILITY;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_MEASURE;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_LEVEL_ATTRIBUTE;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_LEVEL;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_HIERARCHY;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_DIMENSION_ATTRIBUTE;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_DIMENSION;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_CATALOG;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_UTILITY;
drop PACKAGE BODY “OLAPSYS”.CWM2_OLAP_MANAGER;
drop PACKAGE BODY “OLAPSYS”.CWM$UTIL;
drop PACKAGE BODY “OLAPSYS”.CWM$UTILITY;
drop PACKAGE BODY “OLAPSYS”.CWM$OLAP$MEASURE;
drop PACKAGE BODY “OLAPSYS”.CWM$OLAP$LEVEL;
drop PACKAGE BODY “OLAPSYS”.CWM$OLAP$LEVEL$ATTRIBUTE;
drop PACKAGE BODY “OLAPSYS”.CWM$OLAP$HIERARCHY;
drop PACKAGE BODY “OLAPSYS”.CWM$EXPORT;
drop PACKAGE BODY “OLAPSYS”.CWM$OLAP$DIMENSION;
drop PACKAGE BODY “OLAPSYS”.CWM$OLAP$DIM$ATTRIBUTE;
drop PACKAGE BODY “OLAPSYS”.CWM$OLAP$CUBE;
drop PACKAGE BODY “OLAPSYS”.CWM$CLASSIFY;
