-- Remove some portion of the JISish objects created by initjvm5.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 = 'DOWNGRADE_9.2.0_TO_9.0.1' and
         initjvmaux.startstep('JVMRMJIS') then
   update obj$ set status=5 where obj#=(select obj# from obj$,javasnm$ 
      where owner#=0 and type#=29 and short(+)=name and 
      nvl(longdbcs,name)='oracle/aurora/rdbms/Compiler');
  commit;
  initjvmaux.drop_sys_class('HTTPClient/BasicAuthBox$Cancel');
  initjvmaux.drop_sys_class('HTTPClient/BasicAuthBox$Clear');
  initjvmaux.drop_sys_class('HTTPClient/BasicAuthBox$Close');
  initjvmaux.drop_sys_class('HTTPClient/BasicAuthBox$Ok');
  initjvmaux.drop_sys_class('HTTPClient/BasicAuthBox');
  initjvmaux.drop_sys_class('HTTPClient/ExtBufferedInputStream');
  initjvmaux.drop_sys_class('HTTPClient/HTTPConnection$3');
  initjvmaux.drop_sys_class('HTTPClient/HTTPConnection$4');
  initjvmaux.drop_sys_class('HTTPClient/MD5$MD5State');
  initjvmaux.drop_sys_class('com/sun/activation/registries/LineTokenizer');
  initjvmaux.drop_sys_class('com/sun/activation/registries/MailcapEntry');
  initjvmaux.drop_sys_class('com/sun/activation/registries/MailcapFile');
  initjvmaux.drop_sys_class('com/sun/activation/registries/MailcapParseException');
  initjvmaux.drop_sys_class('com/sun/activation/registries/MailcapTokenizer');
  initjvmaux.drop_sys_class('com/sun/activation/registries/MimeTypeEntry');
  initjvmaux.drop_sys_class('com/sun/activation/registries/MimeTypeFile');
  initjvmaux.drop_sys_class('com/sun/activation/viewers/ImageViewer');
  initjvmaux.drop_sys_class('com/sun/activation/viewers/ImageViewerCanvas');
  initjvmaux.drop_sys_class('com/sun/activation/viewers/TextEditor');
  initjvmaux.drop_sys_class('com/sun/activation/viewers/TextViewer');
  initjvmaux.drop_sys_class('com/sun/mail/handlers/message_rfc822');
  initjvmaux.drop_sys_class('com/sun/mail/handlers/multipart_mixed');
  initjvmaux.drop_sys_class('com/sun/mail/handlers/text_html');
  initjvmaux.drop_sys_class('com/sun/mail/handlers/text_plain');
  initjvmaux.drop_sys_class('com/sun/mail/handlers/text_xml');
  initjvmaux.drop_sys_class('com/sun/mail/iap/AString');
  initjvmaux.drop_sys_class('com/sun/mail/iap/Argument');
  initjvmaux.drop_sys_class('com/sun/mail/iap/Atom');
  initjvmaux.drop_sys_class('com/sun/mail/iap/BadCommandException');
  initjvmaux.drop_sys_class('com/sun/mail/iap/ByteArray');
  initjvmaux.drop_sys_class('com/sun/mail/iap/CommandFailedException');
  initjvmaux.drop_sys_class('com/sun/mail/iap/ConnectionException');
  initjvmaux.drop_sys_class('com/sun/mail/iap/Literal');
  initjvmaux.drop_sys_class('com/sun/mail/iap/ParsingException');
  initjvmaux.drop_sys_class('com/sun/mail/iap/Protocol');
  initjvmaux.drop_sys_class('com/sun/mail/iap/ProtocolException');
  initjvmaux.drop_sys_class('com/sun/mail/iap/Response');
  initjvmaux.drop_sys_class('com/sun/mail/iap/ResponseHandler');
  initjvmaux.drop_sys_class('com/sun/mail/iap/ResponseInputStream');
  initjvmaux.drop_sys_class('com/sun/mail/imap/ACL');
  initjvmaux.drop_sys_class('com/sun/mail/imap/DefaultFolder');
  initjvmaux.drop_sys_class('com/sun/mail/imap/IMAPBodyPart');
  initjvmaux.drop_sys_class('com/sun/mail/imap/IMAPFolder$ProtocolCommand');
  initjvmaux.drop_sys_class('com/sun/mail/imap/IMAPFolder');
  initjvmaux.drop_sys_class('com/sun/mail/imap/IMAPInputStream');
  initjvmaux.drop_sys_class('com/sun/mail/imap/IMAPMessage$1$FetchProfileCondition');
  initjvmaux.drop_sys_class('com/sun/mail/imap/IMAPMessage');
  initjvmaux.drop_sys_class('com/sun/mail/imap/IMAPMultipartDataSource');
  initjvmaux.drop_sys_class('com/sun/mail/imap/IMAPNestedMessage');
  initjvmaux.drop_sys_class('com/sun/mail/imap/IMAPStore$ConnectionPool');
  initjvmaux.drop_sys_class('com/sun/mail/imap/IMAPStore');
  initjvmaux.drop_sys_class('com/sun/mail/imap/LengthCounter');
  initjvmaux.drop_sys_class('com/sun/mail/imap/MessageLiteral');
  initjvmaux.drop_sys_class('com/sun/mail/imap/Quota$Resource');
  initjvmaux.drop_sys_class('com/sun/mail/imap/Quota');
  initjvmaux.drop_sys_class('com/sun/mail/imap/Rights$Right');
  initjvmaux.drop_sys_class('com/sun/mail/imap/Rights');
  initjvmaux.drop_sys_class('com/sun/mail/imap/Utility$Condition');
  initjvmaux.drop_sys_class('com/sun/mail/imap/Utility');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/BASE64MailboxDecoder');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/BASE64MailboxEncoder');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/BODY');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/BODYSTRUCTURE');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/ENVELOPE');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/FLAGS');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/FetchResponse');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/IMAPAddress');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/IMAPProtocol');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/IMAPResponse');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/INTERNALDATE');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/Item');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/ListInfo');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/MailboxInfo');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/MessageSet');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/Namespaces$Namespace');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/Namespaces');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/RFC822DATA');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/RFC822SIZE');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/SearchSequence');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/Status');
  initjvmaux.drop_sys_class('com/sun/mail/imap/protocol/UID');
  initjvmaux.drop_sys_class('com/sun/mail/pop3/DefaultFolder');
  initjvmaux.drop_sys_class('com/sun/mail/pop3/POP3Folder');
  initjvmaux.drop_sys_class('com/sun/mail/pop3/POP3Message');
  initjvmaux.drop_sys_class('com/sun/mail/pop3/POP3Store');
  initjvmaux.drop_sys_class('com/sun/mail/pop3/Protocol');
  initjvmaux.drop_sys_class('com/sun/mail/pop3/Response');
  initjvmaux.drop_sys_class('com/sun/mail/pop3/SharedByteArrayOutputStream');
  initjvmaux.drop_sys_class('com/sun/mail/pop3/Status');
  initjvmaux.drop_sys_class('com/sun/mail/smtp/SMTPMessage');
  initjvmaux.drop_sys_class('com/sun/mail/smtp/SMTPOutputStream');
  initjvmaux.drop_sys_class('com/sun/mail/smtp/SMTPTransport');
  initjvmaux.drop_sys_class('com/sun/mail/util/ASCIIUtility');
  initjvmaux.drop_sys_class('com/sun/mail/util/BASE64DecoderStream');
  initjvmaux.drop_sys_class('com/sun/mail/util/BASE64EncoderStream');
  initjvmaux.drop_sys_class('com/sun/mail/util/BEncoderStream');
  initjvmaux.drop_sys_class('com/sun/mail/util/CRLFOutputStream');
  initjvmaux.drop_sys_class('com/sun/mail/util/LineInputStream');
  initjvmaux.drop_sys_class('com/sun/mail/util/LineOutputStream');
  initjvmaux.drop_sys_class('com/sun/mail/util/QDecoderStream');
  initjvmaux.drop_sys_class('com/sun/mail/util/QEncoderStream');
  initjvmaux.drop_sys_class('com/sun/mail/util/QPDecoderStream');
  initjvmaux.drop_sys_class('com/sun/mail/util/QPEncoderStream');
  initjvmaux.drop_sys_class('com/sun/mail/util/SharedByteArrayInputStream');
  initjvmaux.drop_sys_class('com/sun/mail/util/SocketFetcher');
  initjvmaux.drop_sys_class('com/sun/mail/util/TraceInputStream');
  initjvmaux.drop_sys_class('com/sun/mail/util/TraceOutputStream');
  initjvmaux.drop_sys_class('com/sun/mail/util/UUDecoderStream');
  initjvmaux.drop_sys_class('com/sun/mail/util/UUEncoderStream');
  initjvmaux.drop_sys_class('javax/activation/ActivationDataFlavor');
  initjvmaux.drop_sys_class('javax/activation/CommandInfo');
  initjvmaux.drop_sys_class('javax/activation/CommandMap');
  initjvmaux.drop_sys_class('javax/activation/CommandObject');
  initjvmaux.drop_sys_class('javax/activation/DataContentHandler');
  initjvmaux.drop_sys_class('javax/activation/DataContentHandlerFactory');
  initjvmaux.drop_sys_class('javax/activation/DataHandler$1');
  initjvmaux.drop_sys_class('javax/activation/DataHandler');
  initjvmaux.drop_sys_class('javax/activation/DataHandlerDataSource');
  initjvmaux.drop_sys_class('javax/activation/DataSource');
  initjvmaux.drop_sys_class('javax/activation/DataSourceDataContentHandler');
  initjvmaux.drop_sys_class('javax/activation/FileDataSource');
  initjvmaux.drop_sys_class('javax/activation/FileTypeMap');
  initjvmaux.drop_sys_class('javax/activation/MailcapCommandMap');
  initjvmaux.drop_sys_class('javax/activation/MimeType');
  initjvmaux.drop_sys_class('javax/activation/MimeTypeParameterList');
  initjvmaux.drop_sys_class('javax/activation/MimeTypeParseException');
  initjvmaux.drop_sys_class('javax/activation/MimetypesFileTypeMap');
  initjvmaux.drop_sys_class('javax/activation/ObjectDataContentHandler');
  initjvmaux.drop_sys_class('javax/activation/URLDataSource');
  initjvmaux.drop_sys_class('javax/activation/UnsupportedDataTypeException');
  initjvmaux.drop_sys_class('javax/mail/Address');
  initjvmaux.drop_sys_class('javax/mail/AuthenticationFailedException');
  initjvmaux.drop_sys_class('javax/mail/Authenticator');
  initjvmaux.drop_sys_class('javax/mail/BodyPart');
  initjvmaux.drop_sys_class('javax/mail/EventQueue$QueueElement');
  initjvmaux.drop_sys_class('javax/mail/EventQueue');
  initjvmaux.drop_sys_class('javax/mail/FetchProfile$Item');
  initjvmaux.drop_sys_class('javax/mail/FetchProfile');
  initjvmaux.drop_sys_class('javax/mail/Flags$Flag');
  initjvmaux.drop_sys_class('javax/mail/Flags');
  initjvmaux.drop_sys_class('javax/mail/Folder$1');
  initjvmaux.drop_sys_class('javax/mail/Folder');
  initjvmaux.drop_sys_class('javax/mail/FolderClosedException');
  initjvmaux.drop_sys_class('javax/mail/FolderNotFoundException');
  initjvmaux.drop_sys_class('javax/mail/Header');
  initjvmaux.drop_sys_class('javax/mail/IllegalWriteException');
  initjvmaux.drop_sys_class('javax/mail/Message$RecipientType');
  initjvmaux.drop_sys_class('javax/mail/Message');
  initjvmaux.drop_sys_class('javax/mail/MessageAware');
  initjvmaux.drop_sys_class('javax/mail/MessageContext');
  initjvmaux.drop_sys_class('javax/mail/MessageRemovedException');
  initjvmaux.drop_sys_class('javax/mail/MessagingException');
  initjvmaux.drop_sys_class('javax/mail/MethodNotSupportedException');
  initjvmaux.drop_sys_class('javax/mail/Multipart');
  initjvmaux.drop_sys_class('javax/mail/MultipartDataSource');
  initjvmaux.drop_sys_class('javax/mail/NoSuchProviderException');
  initjvmaux.drop_sys_class('javax/mail/Part');
  initjvmaux.drop_sys_class('javax/mail/PasswordAuthentication');
  initjvmaux.drop_sys_class('javax/mail/Provider$Type');
  initjvmaux.drop_sys_class('javax/mail/Provider');
  initjvmaux.drop_sys_class('javax/mail/ReadOnlyFolderException');
  initjvmaux.drop_sys_class('javax/mail/SendFailedException');
  initjvmaux.drop_sys_class('javax/mail/Service$1');
  initjvmaux.drop_sys_class('javax/mail/Service');
  initjvmaux.drop_sys_class('javax/mail/Session');
  initjvmaux.drop_sys_class('javax/mail/Store');
  initjvmaux.drop_sys_class('javax/mail/StoreClosedException');
  initjvmaux.drop_sys_class('javax/mail/Transport');
  initjvmaux.drop_sys_class('javax/mail/UIDFolder$FetchProfileItem');
  initjvmaux.drop_sys_class('javax/mail/UIDFolder');
  initjvmaux.drop_sys_class('javax/mail/URLName');
  initjvmaux.drop_sys_class('javax/mail/event/ConnectionAdapter');
  initjvmaux.drop_sys_class('javax/mail/event/ConnectionEvent');
  initjvmaux.drop_sys_class('javax/mail/event/ConnectionListener');
  initjvmaux.drop_sys_class('javax/mail/event/FolderAdapter');
  initjvmaux.drop_sys_class('javax/mail/event/FolderEvent');
  initjvmaux.drop_sys_class('javax/mail/event/FolderListener');
  initjvmaux.drop_sys_class('javax/mail/event/MailEvent');
  initjvmaux.drop_sys_class('javax/mail/event/MessageChangedEvent');
  initjvmaux.drop_sys_class('javax/mail/event/MessageChangedListener');
  initjvmaux.drop_sys_class('javax/mail/event/MessageCountAdapter');
  initjvmaux.drop_sys_class('javax/mail/event/MessageCountEvent');
  initjvmaux.drop_sys_class('javax/mail/event/MessageCountListener');
  initjvmaux.drop_sys_class('javax/mail/event/StoreEvent');
  initjvmaux.drop_sys_class('javax/mail/event/StoreListener');
  initjvmaux.drop_sys_class('javax/mail/event/TransportAdapter');
  initjvmaux.drop_sys_class('javax/mail/event/TransportEvent');
  initjvmaux.drop_sys_class('javax/mail/event/TransportListener');
  initjvmaux.drop_sys_class('javax/mail/internet/AddressException');
  initjvmaux.drop_sys_class('javax/mail/internet/AsciiOutputStream');
  initjvmaux.drop_sys_class('javax/mail/internet/ContentDisposition');
  initjvmaux.drop_sys_class('javax/mail/internet/ContentType');
  initjvmaux.drop_sys_class('javax/mail/internet/HeaderTokenizer$Token');
  initjvmaux.drop_sys_class('javax/mail/internet/HeaderTokenizer');
  initjvmaux.drop_sys_class('javax/mail/internet/InternetAddress');
  initjvmaux.drop_sys_class('javax/mail/internet/InternetHeaders');
  initjvmaux.drop_sys_class('javax/mail/internet/MailDateFormat');
  initjvmaux.drop_sys_class('javax/mail/internet/MailDateParser');
  initjvmaux.drop_sys_class('javax/mail/internet/MimeBodyPart');
  initjvmaux.drop_sys_class('javax/mail/internet/MimeMessage$RecipientType');
  initjvmaux.drop_sys_class('javax/mail/internet/MimeMessage');
  initjvmaux.drop_sys_class('javax/mail/internet/MimeMultipart');
  initjvmaux.drop_sys_class('javax/mail/internet/MimePart');
  initjvmaux.drop_sys_class('javax/mail/internet/MimePartDataSource');
  initjvmaux.drop_sys_class('javax/mail/internet/MimeUtility$1$NullInputStream');
  initjvmaux.drop_sys_class('javax/mail/internet/MimeUtility');
  initjvmaux.drop_sys_class('javax/mail/internet/NewsAddress');
  initjvmaux.drop_sys_class('javax/mail/internet/ParameterList');
  initjvmaux.drop_sys_class('javax/mail/internet/ParseException');
  initjvmaux.drop_sys_class('javax/mail/internet/SharedInputStream');
  initjvmaux.drop_sys_class('javax/mail/internet/UniqueValue');
  initjvmaux.drop_sys_class('javax/mail/internet/hdr');
  initjvmaux.drop_sys_class('javax/mail/internet/matchEnum');
  initjvmaux.drop_sys_class('javax/mail/search/AddressStringTerm');
  initjvmaux.drop_sys_class('javax/mail/search/AddressTerm');
  initjvmaux.drop_sys_class('javax/mail/search/AndTerm');
  initjvmaux.drop_sys_class('javax/mail/search/BodyTerm');
  initjvmaux.drop_sys_class('javax/mail/search/ComparisonTerm');
  initjvmaux.drop_sys_class('javax/mail/search/DateTerm');
  initjvmaux.drop_sys_class('javax/mail/search/FlagTerm');
  initjvmaux.drop_sys_class('javax/mail/search/FromStringTerm');
  initjvmaux.drop_sys_class('javax/mail/search/FromTerm');
  initjvmaux.drop_sys_class('javax/mail/search/HeaderTerm');
  initjvmaux.drop_sys_class('javax/mail/search/IntegerComparisonTerm');
  initjvmaux.drop_sys_class('javax/mail/search/MessageIDTerm');
  initjvmaux.drop_sys_class('javax/mail/search/MessageNumberTerm');
  initjvmaux.drop_sys_class('javax/mail/search/NotTerm');
  initjvmaux.drop_sys_class('javax/mail/search/OrTerm');
  initjvmaux.drop_sys_class('javax/mail/search/ReceivedDateTerm');
  initjvmaux.drop_sys_class('javax/mail/search/RecipientStringTerm');
  initjvmaux.drop_sys_class('javax/mail/search/RecipientTerm');
  initjvmaux.drop_sys_class('javax/mail/search/SearchException');
  initjvmaux.drop_sys_class('javax/mail/search/SearchTerm');
  initjvmaux.drop_sys_class('javax/mail/search/SentDateTerm');
  initjvmaux.drop_sys_class('javax/mail/search/SizeTerm');
  initjvmaux.drop_sys_class('javax/mail/search/StringTerm');
  initjvmaux.drop_sys_class('javax/mail/search/SubjectTerm');
  initjvmaux.drop_sys_resource('javax/net/ssl/SSLSession.classx');
  initjvmaux.drop_sys_resource('META-INF/MANIFEST.MF');
  initjvmaux.drop_sys_resource('META-INF/javamail.charset.map');
  initjvmaux.drop_sys_resource('META-INF/javamail.default.address.map');
  initjvmaux.drop_sys_resource('META-INF/javamail.default.providers');
  initjvmaux.drop_sys_resource('META-INF/mailcap');
  initjvmaux.drop_sys_resource('META-INF/mailcap.default');
  initjvmaux.drop_sys_resource('META-INF/mimetypes.default');
  initjvmaux.endstep;
end if; end;
/

begin if :jvmrmaction = 'DOWNGRADE_9.2.0_TO_9.0.1' and
         initjvmaux.startstep('JVRMJIS_COMPILER_ON') then
   update obj$ set status=1 where obj#=(select obj# from obj$,javasnm$ 
      where owner#=0 and type#=29 and short(+)=name and 
      nvl(longdbcs,name)='oracle/aurora/rdbms/Compiler');
  commit;
  initjvmaux.endstep;
end if; end;
/