-- Remove some portion of the dictionary objects created by initprefs.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' or
         :jvmrmaction = 'DOWNGRADE_10.1.0_TO_9.2.0') and
          initjvmaux.startstep('JVMRMPREFS')) then

initjvmaux.drp('drop table JAVA$PREFS$');
initjvmaux.drp('drop sequence JAVA$PREFS$SEQ$');

if :jvmrmaction = 'GRADE_REMOVAL' or
   :jvmrmaction = 'DOWNGRADE_10.1.0_TO_9.2.0'
   then initjvmaux.endstep; end if;

end if;end;
/