SELECT owner, object_type, status, COUNT(*)
  FROM dba_objects
 WHERE object_type LIKE %JAVA%
       AND owner NOT IN (SYS, OJVMSYS, EXFSYS)
 GROUP BY owner, object_type, status
 ORDER BY owner, object_type, status;

connect / as sysdba
startup mount
alter database open;
alter system enable restricted session;
alter system set "_system_trig_enabled" = false scope=memory;

spool force_removal.txt
set echo on

@?/rdbms/admin/catnoexf.sql
@?/rdbms/admin/catnojav.sql

truncate table java$jvm$status;
delete from obj$ where obj#=0 and type#=0;
commit;

select count(*) from obj$ where type#=29 and owner#=0;

delete from sys.registry$ where cid in (JAVAVM,CATJAVA,EXF);
commit;

set echo off
spool off

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

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

delete from sys.exppkgact$ where package = DBMS_AW_EXP and schema= SYS;
delete from exppkgact$ where package=DBMS_CUBE_EXP;
commit;

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk olap_off
make -f ins_rdbms.mk ioracle

conn / as sysdba
@?/rdbms/admin/dvremov.sql

connect / as sysdba
@?/rdbms/admin/catnools.sql

connect / as sysdba
@?xdkadmin
mxml.sql

delete from sys.registry$ where cid in (XML);
commit;

drop index .;
-- If some indexes cannot be dropped use the FORCE option:
drop index . force;

set pagesize 0
spool DropIndexes.sql
select drop index  || owner || . || index_name ||;
from dba_indexes where ityp_name = SPATIAL_INDEX;
spool off@DropIndexes.sql

set pages 200
col owner for a20
col table_name for a30
col column_name for a25

select owner, table_name, column_name
from dba_tab_columns
where data_type = SDO_GEOMETRY
and owner != MDSYS
order by 1,2,3;

set pagesize 0
spool DropTables.sql
select drop table || owner ||.|| table_name||;
from dba_tab_columns
where data_type = SDO_GEOMETRY
and owner != MDSYS;
spool off
@DropTables.sql

set pagesize 0
set feed off
spool dropsyn.sql
select drop public synonym " || synonym_name || "; from dba_synonyms where table_owner=MDSYS;
spool off;
@dropsyn.sql

drop user mddata cascade;
-- Only created as of release 11g:
drop user spatial_csw_admin_usr cascade;
drop user spatial_wfs_admin_usr cascade;

select username from dba_users where username like ‘APEX%’;
select username from dba_users where username like ‘FLOWS%’;

select drop public synonym  || synonym_name || CHR(10) || / from sys.dba_synonyms
where table_owner in (步骤2中查到的用户名);