spool full_rmjvm.log set echo on connect internal startup restrict show parameters _system @?/rdbms/admin/rmrepapi.sql @?/oracore/admin/rmxml.sql select trigger_name from user_triggers where trigger_name like '%JIS%'; drop trigger JIS$ROLE_TRIGGER$; select owner, pack, proc from duc$ where owner='SYS' and pack='JIS$INTERCEPTOR$' and proc='USER_DROPPED'; delete from duc$ where owner='SYS' and pack='JIS$INTERCEPTOR$' and proc='USER_DROPPED'; select classname from aurora$startup$classes$ where classname='oracle.aurora.mts.http.admin.RegisterService'; delete from aurora$startup$classes$ where classname='oracle.aurora.mts.http.admin.RegisterService'; select count(*) from aurora$dyn$reg; delete from aurora$dyn$reg; commit; @?/javavm/install/rmjvm.sql select * from obj$ where obj#=0 and type#=0; delete from obj$ where obj#=0 and type#=0; select name from sys.java$class$md5$table; drop table sys.java$class$md5$table; select owner, count(*) from all_objects where object_type like '%JAVA%' group by owner; select obj#, name from obj$ where type#=28 or type#=29 or type#=30 or namespace=32; select o1.name from obj$ o1,obj$ o2 where o1.type#=5 and o1.owner#=1 and o1.name=o2.name and o2.type#=29; shutdown immediate set echo off spool off exit