Rem
Rem $Header: sdo/admin/loce111.sql /st_sdo_11.2.0/1 2011/04/06 08:14:16 mhorhamm Exp $
Rem
Rem loce111.sql
Rem
Rem Copyright (c) 2008, 2011, Oracle and/or its affiliates. 
Rem All rights reserved. 
Rem
Rem    NAME
Rem      loce111.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    sravada     04/02/09 - bug 8400863
Rem    sravada     12/03/08 - drop AggrSetUnion
Rem    yhu         07/23/08 - add sdopopt downgrade
Rem    sravada     02/14/08 - Created
Rem

ALTER SESSION SET CURRENT_SCHEMA = MDSYS;

-- drop SDO_Aggr_Set_Union
drop public synonym SDO_Aggr_Set_Union;
drop function MDSYS.SDO_Aggr_Set_Union;

-- Drop objects related to sdopopt.sql 
----------------------------------------------------------------------
drop public synonym SDO_PQRY force;
drop public synonym sdoridtable force;
drop function MDSYS.SDO_PQRY;
drop function MDSYS.qry2opt;
drop function MDSYS.sdo_simple_filter;
drop type MDSYS.sdoridtable force;

@@sdoeoper.sql

-- Drop 3D WKT column in sdo_cs_srs and cs_srs
----------------------------------------------------------------------
begin
begin
  execute immediate 'alter table mdsys.sdo_cs_srs drop column wktext3d';
  exception
    when others then null;
end;

begin
   execute immediate 'drop trigger MDSYS.SDO_PREFERRED_OPS_SYSTEM_TRIG ';
   exception
    when others then null;
end;

begin
   execute immediate 'drop trigger MDSYS.SDO_COORD_OPS_TRIGGER ';
   exception
    when others then null;
end;

begin
   execute immediate 'drop package MDSYS.SDO_TOPO_METADATA_INT ';
   exception
    when others then null;
end;

end;
/

CREATE or replace VIEW MDSYS.CS_SRS AS (SELECT * FROM MDSYS.SDO_CS_SRS);

drop trigger MDSYS.SDO_CRS_INSERT_TRIGGER;

drop trigger MDSYS.SDO_coord_op_param_val_TRIGG2;

-- Drop triggers involving MDSYS.sdo_cs.sdo_cs_context_invalidate:

-- From sdoepsgl2.sql
begin
  execute immediate 'drop TRIGGER MDSYS.SDO_PREFERRED_OPS_SYS_TRIGGER';
  exception
    when others then null;
end;
/

begin
  execute immediate 'drop TRIGGER MDSYS.SDO_PREFERRED_OPS_USER_TRIGGER';
  exception
    when others then null;
end;
/

begin
  execute immediate 'drop TRIGGER MDSYS.SDO_COORD_OP_PATHS_TRIGGER';
  exception
    when others then null;
end;
/

-- From sdoepsgv.sql
begin
  execute immediate 'drop TRIGGER MDSYS.CS_SRS_TRIGGER';
  exception
    when others then null;
end;
/

begin
  execute immediate 'drop TRIGGER MDSYS.SDO_coord_op_param_val_TRIGGER';
  exception
    when others then null;
end;
/

commit;

ALTER SESSION SET CURRENT_SCHEMA = SYS;

alter session set current_schema=SYS;
COLUMN java_fname NEW_VALUE java_file NOPRINT;
SELECT dbms_registry.script('JAVAVM','@sdounloadj.sql') AS java_fname FROM DUAL;
@&java_file



ALTER SESSION SET CURRENT_SCHEMA = SYS;