Rem
Rem $Header: cwmlite/admin/amde920.sql /main/8 2008/07/28 13:25:50 glyon Exp $
Rem
Rem amde920.sql
Rem
Rem Copyright (c) 2001, 2008, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      amde920.sql -
Rem
Rem    DESCRIPTION
Rem
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    glyon       07/16/08 - restore select privilege on sys.user$
Rem    cdalessi    05/18/05 - drop odm$olap2udim_hier_level_uses
Rem    cdalessi    03/01/05 - drop sys.cwm2_olap_installer
Rem    cdalessi    04/26/04 - drop 10.1-specific packages
Rem    cdalessi    06/20/03 - downgraded call
Rem    cdalessi    06/19/03 - 10i migration fixes
Rem    cdalessi    12/09/02 - 10i migration changes
Rem    cdalessi    10/18/02 - cdalessi_txn103996
Rem    cdalessi    10/11/02 - Creation

alter session set current_schema = olapsys;

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

drop package sys.dbms_amd;
drop package sys.cwm2_olap_installer;
drop type o_mesg_row force;
drop view odm$olap2udim_hier_level_uses;

grant select on sys.user$ to olapsys;

execute sys.dbms_registry.downgraded('AMD', '9.2.0');

alter session set current_schema = sys;