Rem
Rem $Header: seme101.sql 17-jun-2007.10:18:38 sdas Exp $
Rem
Rem seme101.sql
Rem
Rem Copyright (c) 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      seme101.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    sdas        06/17/07 - uninstalls 10.2 RDF (taken from sdoe101.sql)
Rem    sdas        06/17/07 - Created
Rem

set echo off

alter session set current_schema=MDSYS;

-- RDF section
declare
begin
   begin
    execute immediate ' drop public synonym sdo_rdf_triple_s ';
          exception when others then NULL;
   end;
   begin
    execute immediate 'drop public synonym sdo_rdf_triple ';
          exception when others then NULL;
   end;
   begin
    execute immediate 'drop public synonym sdo_rdf ';
          exception when others then NULL;
   end;
   begin
    execute immediate 'drop package sdo_rdf ';
          exception when others then NULL;
   end;
   begin
    execute immediate 'drop public synonym sdo_rdf_internal ';
          exception when others then NULL;
   end;
   begin
    execute immediate 'drop package sdo_rdf_internal ';
          exception when others then NULL;
   end;
   begin
    execute immediate ' drop type body sdo_rdf_triple_s ';
          exception when others then NULL;
   end;
end;
/

declare
begin
   begin
      execute immediate ' drop table RDF_RULEBASE_MEMBER$ ';
        exception when others then NULL;
   end;

   begin
      execute immediate ' drop table RDF_RULE$ ';
        exception when others then NULL;
   end;
    
   begin
      execute immediate ' drop table RDF_RULEBASE$ ';
        exception when others then NULL;
   end;

   begin
      execute immediate ' drop table RDF_PRECOMP_DEP$ ';
        exception when others then NULL;
   end;

   begin
      execute immediate ' drop table RDF_PRECOMP$ ';
        exception when others then NULL;
   end;

   begin
      execute immediate ' drop table RDF_PRECOMP$ ';
        exception when others then NULL;
   end;

   begin
      execute immediate ' drop package RDF_APIS ';
        exception when others then NULL;
   end;

   begin
      execute immediate ' drop package RDF_APIS_INTERNAL ';
        exception when others then NULL;
   end;

   begin
      execute immediate ' drop package RDF_APIS_USER ';
        exception when others then NULL;
   end;

   begin
      execute immediate ' drop procedure load_predefined_rulebases ';
        exception when others then NULL;
   end;

   begin
      execute immediate ' drop type RDF_MATCH_impl_t ';
        exception when others then NULL;
   end;

   begin
      execute immediate ' drop function RDF_MATCH ';
        exception when others then NULL;
   end;

   begin
      execute immediate ' drop public synonym SDO_RDF_MATCH ';
        exception when others then NULL;
   end;

   begin
      execute immediate ' drop public synonym RDF_APIS_INTERNAL ';
        exception when others then NULL;
   end;

   begin
      execute immediate ' drop public synonym SDO_RDF_INFERENCE ';
        exception when others then NULL;
   end;

   begin
      execute immediate ' drop trigger sdo_drop_user_before ';
        exception when others then NULL;
   end;

   -- added
   begin
      execute immediate ' drop package VALUE$CACHE ';
      exception when others then NULL;
   end;
     
end;
/

alter session set current_schema=SYS;
call dbms_java.dropjava('-force -synonym -schema MDSYS  md/lib/sdordf.jar');