Rem
Rem $Header: sdo/admin/seme102.sql /main/4 2008/09/03 22:35:24 vkolovsk Exp $
Rem
Rem seme102.sql
Rem
Rem Copyright (c) 2007, 2008, Oracle. All rights reserved.
Rem
Rem    NAME
Rem      seme102.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    vkolovsk    09/03/08 - need to drop sameas related packages and types
Rem    sdas        06/17/07 - drop upgrade package if present
Rem    sdas        06/15/07 - drop sdo_sem_downgrade_utl
Rem    alwu        06/01/07 - add logic to remove 11g downgrade package
Rem    sdas        05/24/07 - Semantic Store downgrade
Rem    sdas        05/24/07 - Created
Rem

ALTER SESSION SET CURRENT_SCHEMA = MDSYS;

declare
  stmt VARCHAR2(1000);
begin
   begin
      stmt := 'drop type sdo_sem_stats force'; execute immediate stmt;
      exception when others then null;
   end;
 
   begin
      stmt := 'drop indextype sem_indextype force';  execute immediate stmt;
      exception when others then null;
    end;

   begin
      stmt := 'drop public synonym sem_path'; execute immediate stmt;
      exception when others then null;
    end;

   begin
      stmt := 'drop operator sem_path force'; execute immediate stmt;
      exception when others then null;
    end;

   begin
      stmt := 'drop public synonym sem_distance'; execute immediate stmt;
      exception when others then null;
    end;

   begin
      stmt := 'drop operator sem_distance force'; execute immediate stmt;
      exception when others then null;
    end;

   begin
      stmt := 'drop public synonym sem_related'; execute immediate stmt;
      exception when others then null;
    end;

   begin
      stmt := 'drop operator sem_related force'; execute immediate stmt;
      exception when others then null;
    end;

   begin
      stmt := 'drop package sdo_sem_operator'; execute immediate stmt;
      exception when others then null;
    end;

   begin
      stmt := 'drop type sem_sameas_list force';  execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop type sem_sameas_rec force';  execute immediate stmt;
      exception when others then null;
    end;

   begin
      stmt := 'drop type sem_indextype_im force';  execute immediate stmt;
      exception when others then null;
    end;

   begin
      stmt := 'drop type sdo_bt_handle'; execute immediate stmt;
      exception when others then null;
    end;

   begin
      stmt := 'drop package sdo_sem_bt'; execute immediate stmt;
      exception when others then null;
    end;

   begin
      stmt := 'drop package rdf_apis_oper_internal'; execute immediate stmt;
      exception when others then null;
    end;

   begin
      stmt := 'drop package sdo_sem_inference'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop package sdo_sem_infh'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop package sdo_sem_infi'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop package sdo_sem_utl'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop package sem_upgrade_to_11'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop package sdo_sem_downgrade_utl'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop package sdo_rdf_mig'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop package sdo_sem_validate'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop package sdo_sem_downgrade'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop package sdo_sem_perf'; execute immediate stmt;
      exception when others then null;
   end;
   
   begin
      stmt := 'drop package sdo_sem_cli'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop public synonym SEM_INF_HIST'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop public synonym SEM_PERF'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop view mdsys.sem_inf_hist'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop table mdsys.rdf_hist$'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop sequence mdsys.rdf_hist_id_sq'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop package mdsys.sdo_sem_log'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop package mdsys.sdo_sem_magic'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop type mdsys.sem_vars_table force'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop type mdsys.sem_pred_array force'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop type mdsys.sem_predicate force'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop type mdsys.sem_rule force'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop type mdsys.sem_node force'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop type mdsys.sem_nodes_array force'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop type mdsys.sem_rule_node force'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop type mdsys.sem_goal_node force'; execute immediate stmt;
      exception when others then null;
   end;

   begin
      stmt := 'drop type mdsys.sem_rules_table force'; execute immediate stmt;
      exception when others then null;
   end;

   begin
     stmt := 'drop type mdsys.sem_graph force'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop type mdsys.sem_terms_table'; execute immediate stmt;
      exception when others then null;
   end;

   begin
     stmt := 'drop type mdsys.sem_term'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop type mdsys.sem_term'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop trigger mdsys.sdo_sem_drop_trigger'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop trigger mdsys.sdo_sem_alter_trigger'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SEM_APIS'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop package mdsys.sdo_rdf'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop package mdsys.rdf_apis_user'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop package mdsys.rdf_apis'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop package mdsys.sdo_rdf_inference'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop package mdsys.rdf_apis_internal'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop package mdsys.sdo_rdf_internal'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop package mdsys.sdo_sem_const'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop package mdsys.sem_hash_internal'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SEM_VARCHARARRAY force'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop type mdsys.RDF_VARCHARARRAY force'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SEM_LONGVARCHARARRAY force'; execute immediate stmt; 
     exception when others then null;
   end;

   begin
     stmt := 'drop type mdsys.RDF_LONGVARCHARARRAY force'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SEM_MATCH'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym RDF_MATCH'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop function mdsys.RDF_MATCH'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop type mdsys.RDF_MATCH_IMPL_T force'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SEM_ALIASES'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop type mdsys.RDF_ALIASES force'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SEM_ALIAS'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop type mdsys.RDF_ALIAS force'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop type mdsys.SDO_RDF_TRIPLE force'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop type mdsys.SDO_RDF_TRIPLE_S force'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop procedure mdsys.LOAD_PREDEFINED_RULEBASES'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop context SDO_SEM_CTX'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop package mdsys.SDO_SEM_CTX'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SEM_MODELS'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop type mdsys.RDF_MODELS force'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SEM_RULEBASES'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop type mdsys.RDF_RULEBASES force'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SDO_RDF_RULEBASES'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SDO_RDF_MODELS'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SDO_RDF_ALIAS'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SDO_RDF_ALIASES'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SDO_RDF_INFERENCE'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SDO_RDF_MATCH'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SDO_RDF_INTERNAL'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SDO_RDF'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SDO_RDF_TRIPLE'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SDO_RDF_TRIPLE_S'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SDO_SEM_INFERENCE'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SDO_SEM_VALIDATE'; execute immediate stmt;
     exception when others then null;
   end;

   begin
     stmt := 'drop public synonym SDO_SEM'; execute immediate stmt;
     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');