Rem
Rem Copyright (c) 2004, 2009, Oracle and/or its affiliates. 
Rem All rights reserved. 
Rem
Rem    NAME
Rem      xoqe101.sql - migration script for downgrading olap api component
Rem
Rem    DESCRIPTION
Rem      Downgrade OLAP API from 10.1.0
Rem
Rem    NOTES
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    akociube    04/08/09 - Add drop of dbms_cube_util
Rem    csperry     10/27/08 - change for dbms_cube.derive_from_mview objects
Rem    csperry     09/17/08 - Drop dbms_cube_derive_from_mview related objects
Rem    csperry     05/14/08 - drop dbms_cube.derive_from_table related objects
Rem    csperry     05/29/07 - drop dbms_cube_advise
Rem    glyon       05/05/07 - drop dbms_cube and dbms_cube_exp packages
Rem    glyon       02/28/07 - drop AWXML from embedded JVM (incompatible)
Rem    cdalessi    05/26/04 - cdalessi_txn111650
Rem    cdalessi    05/26/04 - Creation

execute sys.dbms_registry.downgrading('XOQ');

call dbms_java.dropjava('-force -synonym olap/api/lib/awxml.jar');
call dbms_java.dropjava('-force -synonym olap/api/lib/olap_api_spl.jar');

drop package dbms_cube;
drop package dbms_cube_exp;

--Drop dbms_cube_advise
drop package dbms_cube_advise;
drop package dbms_cube_advise_sec;
drop type coad_advice_t;
drop type coad_advice_rec;
drop sequence  DBMS_CUBE_ADVICE_SEQ$;

--Drop objects used by dbms_cube.derive_from_mview
drop table sam_sparsity_advice;
drop type SAM_MEASURE_SPECS_T;
drop type SAM_MEASURE_SPEC_R;
drop type SAM_RELATION_SPECS_T;
drop type SAM_RELATION_SPEC_R;

DROP PUBLIC SYNONYM DBMS_CUBE_UTIL;
DROP PACKAGE DBMS_CUBE_UTIL;

execute sys.dbms_registry.downgraded('XOQ','10.1.0');