Edit D:\app\Administrator\product\11.2.0\dbhome_1\javavm\install\jvmrmcat.sql
-- Remove the dictionary objects created by catjvm.sql -- This script must be run as a subscript of a script which sets the -- variable jvmrmaction. -- Possible values are -- FULL_REMOVAL: remove all java related objects -- GRADE_REMOVAL: remove java related objects for general up/downgrade -- DOWNGRADE_x.y.z_TO_a.b.c: remove or massage system objects as appropriate -- when downgrading to release a.b.c -- NONE: do nothing print jvmrmaction begin if (:jvmrmaction = 'FULL_REMOVAL' or :jvmrmaction = 'GRADE_REMOVAL') and initjvmaux.startstep('JVMRMCAT') then initjvmaux.drp('drop view USER_JAVA_CLASSES'); initjvmaux.drp('drop public synonym USER_JAVA_CLASSES'); initjvmaux.drp('drop view ALL_JAVA_CLASSES'); initjvmaux.drp('drop public synonym ALL_JAVA_CLASSES'); initjvmaux.drp('drop view DBA_JAVA_CLASSES'); initjvmaux.drp('drop public synonym DBA_JAVA_CLASSES'); initjvmaux.drp('drop view USER_JAVA_LAYOUTS'); initjvmaux.drp('drop public synonym USER_JAVA_LAYOUTS'); initjvmaux.drp('drop view ALL_JAVA_LAYOUTS'); initjvmaux.drp('drop public synonym ALL_JAVA_LAYOUTS'); initjvmaux.drp('drop view DBA_JAVA_LAYOUTS'); initjvmaux.drp('drop public synonym DBA_JAVA_LAYOUTS'); initjvmaux.drp('drop view USER_JAVA_IMPLEMENTS'); initjvmaux.drp('drop public synonym USER_JAVA_IMPLEMENTS'); initjvmaux.drp('drop view ALL_JAVA_IMPLEMENTS'); initjvmaux.drp('drop public synonym ALL_JAVA_IMPLEMENTS'); initjvmaux.drp('drop view DBA_JAVA_IMPLEMENTS'); initjvmaux.drp('drop public synonym DBA_JAVA_IMPLEMENTS'); initjvmaux.drp('drop view USER_JAVA_INNERS'); initjvmaux.drp('drop public synonym USER_JAVA_INNERS'); initjvmaux.drp('drop view ALL_JAVA_INNERS'); initjvmaux.drp('drop public synonym ALL_JAVA_INNERS'); initjvmaux.drp('drop view DBA_JAVA_INNERS'); initjvmaux.drp('drop public synonym DBA_JAVA_INNERS'); initjvmaux.drp('drop view USER_JAVA_FIELDS'); initjvmaux.drp('drop public synonym USER_JAVA_FIELDS'); initjvmaux.drp('drop view ALL_JAVA_FIELDS'); initjvmaux.drp('drop public synonym ALL_JAVA_FIELDS'); initjvmaux.drp('drop view DBA_JAVA_FIELDS'); initjvmaux.drp('drop public synonym DBA_JAVA_FIELDS'); initjvmaux.drp('drop view USER_JAVA_METHODS'); initjvmaux.drp('drop public synonym USER_JAVA_METHODS'); initjvmaux.drp('drop view ALL_JAVA_METHODS'); initjvmaux.drp('drop public synonym ALL_JAVA_METHODS'); initjvmaux.drp('drop view DBA_JAVA_METHODS'); initjvmaux.drp('drop public synonym DBA_JAVA_METHODS'); initjvmaux.drp('drop view USER_JAVA_ARGUMENTS'); initjvmaux.drp('drop public synonym USER_JAVA_ARGUMENTS'); initjvmaux.drp('drop view ALL_JAVA_ARGUMENTS'); initjvmaux.drp('drop public synonym ALL_JAVA_ARGUMENTS'); initjvmaux.drp('drop view DBA_JAVA_ARGUMENTS'); initjvmaux.drp('drop public synonym DBA_JAVA_ARGUMENTS'); initjvmaux.drp('drop view USER_JAVA_THROWS'); initjvmaux.drp('drop public synonym USER_JAVA_THROWS'); initjvmaux.drp('drop view ALL_JAVA_THROWS'); initjvmaux.drp('drop public synonym ALL_JAVA_THROWS'); initjvmaux.drp('drop view DBA_JAVA_THROWS'); initjvmaux.drp('drop public synonym DBA_JAVA_THROWS'); initjvmaux.drp('drop view USER_JAVA_DERIVATIONS'); initjvmaux.drp('drop public synonym USER_JAVA_DERIVATIONS'); initjvmaux.drp('drop view ALL_JAVA_DERIVATIONS'); initjvmaux.drp('drop public synonym ALL_JAVA_DERIVATIONS'); initjvmaux.drp('drop view DBA_JAVA_DERIVATIONS'); initjvmaux.drp('drop public synonym DBA_JAVA_DERIVATIONS'); initjvmaux.drp('drop view USER_JAVA_RESOLVERS'); initjvmaux.drp('drop public synonym USER_JAVA_RESOLVERS'); initjvmaux.drp('drop view ALL_JAVA_RESOLVERS'); initjvmaux.drp('drop public synonym ALL_JAVA_RESOLVERS'); initjvmaux.drp('drop view DBA_JAVA_RESOLVERS'); initjvmaux.drp('drop public synonym DBA_JAVA_RESOLVERS'); initjvmaux.drp('drop view USER_JAVA_NCOMPS'); initjvmaux.drp('drop public synonym USER_JAVA_NCOMPS'); initjvmaux.drp('drop view ALL_JAVA_NCOMPS'); initjvmaux.drp('drop public synonym ALL_JAVA_NCOMPS'); initjvmaux.drp('drop view DBA_JAVA_NCOMPS'); initjvmaux.drp('drop public synonym DBA_JAVA_NCOMPS'); initjvmaux.drp('drop view USER_JAVA_COMPILER_OPTIONS'); initjvmaux.drp('drop public synonym USER_JAVA_COMPILER_OPTIONS'); initjvmaux.drp('drop view ALL_JAVA_COMPILER_OPTIONS'); initjvmaux.drp('drop public synonym ALL_JAVA_COMPILER_OPTIONS'); initjvmaux.drp('drop view DBA_JAVA_COMPILER_OPTIONS'); initjvmaux.drp('drop public synonym DBA_JAVA_COMPILER_OPTIONS'); initjvmaux.endstep; end if;end; /
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de