Edit D:\app\Administrator\product\11.2.0\dbhome_1\javavm\install\rmjvm.sql
Rem Rem $Header: rmjvm.sql 04-dec-2006.15:08:04 mjungerm Exp $ Rem Rem rmjvm.sql Rem Rem Copyright (c) 2006, Oracle. All rights reserved. Rem Rem NAME Rem rmjvm.sql - Remove all java objects Rem Rem DESCRIPTION Rem This removes all the java objects from the data dictionary. Rem Rem NOTES Rem WARNING: This script is highly destructive. It should Rem only be run if you wish to remove all Java objects Rem from a database. Once this script is run all of your Rem java objects will be gone unless you have a backup!!! Rem Rem This script requires a significant amount of rollback Rem to execute. Rem Rem Rem MODIFIED (MM/DD/YY) Rem mjungerm 01/28/99 - Created from utljavarm.sql Rem REM Java objects have a format change between 8.1.4 and 8.1.5. REM We have to remove all java objects between these releases REM because they are not compatible. @@initjvma set echo on set serveroutput on size 999999 variable jvmudaction varchar2(30) variable jvmudsubaction varchar2(30) variable jvmrmaction varchar2(30) execute :jvmrmaction := 'FULL_REMOVAL'; @@jvmrm begin execute immediate 'drop package rmjvm'; execute immediate 'drop package initjvmaux'; execute immediate 'drop table JAVA$JVM$STEPS$DONE'; execute immediate 'drop table JAVA$JVM$STATUS'; end; / REM REM end java object removal REM
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de