Rem
Rem Copyright (c) 2008, 2009, Oracle and/or its affiliates. 
Rem All rights reserved. 
Rem
Rem    NAME
Rem      xoqe111.sql - migration script for downgrading olap api component
Rem
Rem    DESCRIPTION
Rem      Downgrade OLAP API from 11.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 - Downgrade derive_from_table objs
Rem    jhartsin    02/21/08 - 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;

-- all DROPs from dbmscbu.sql
DROP PUBLIC SYNONYM DBMS_CUBE_UTIL;
DROP PACKAGE DBMS_CUBE_UTIL;

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