Rem
Rem Copyright (c) 2004, 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      apse101.sql - migration script for downgrading olap aw component
Rem
Rem    DESCRIPTION
Rem      Downgrade OLAP AW to 10.1.0
Rem
Rem    NOTES
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    ckearney    06/08/06 - add call to 10.2 downgrade script
Rem    zqiu        08/26/05 - remove drops 
Rem    zqiu        08/19/05 - columnlist not column_list 
Rem    cchiappa    01/19/05 - Drop sparsity advisor types 
Rem    cchiappa    12/15/04 - Drop DBMS_AW_XML 
Rem    cchiappa    07/13/04 - Drop DBMS_AW_EXP types 
Rem    cchiappa    06/21/04 - Upgrade/downgrade for OLAP TTS support
Rem    cdalessi    05/26/04 - Creation

Rem
Rem Call 10.2 downgrade script
Rem
@@apse102.sql

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

DELETE FROM sys.expdepact$ WHERE package='DBMS_AW_EXP' AND schema='SYS';

DROP PUBLIC SYNONYM dbms_aw_xml
/
DROP PACKAGE sys.dbms_aw_xml;
/

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