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