1. Remove Oracle Text:
***********************

@?/ctx/admin/catnoctx.sql

drop procedure sys.validate_context;

select comp_id, comp_name, version, status from dba_registry where COMP_ID=’CONTEXT’;
SELECT object_name FROM dba_objects WHERE status = ‘INVALID’;

2. Remove OLAP Analytic Workspace:
************************************

shutdown immediate;
startup

@?/olap/admin/catnoaps.sql

alter public synonym DBA_AW_PROP compile;
alter public synonym USER_AW_PROP compile;
alter public synonym ALL_AW_PROP compile;

Recommended Posts

Start typing and press Enter to search