REM
REM  Copyright (c) Oracle Corporation 2002. All Rights Reserved.
REM
REM  NAME
REM   cwm2upg.sql
REM
REM  DESCRIPTION
REM   This scripts is needed for a clean upgrade from 9i1 to 9i2
REM   There are a few objects that are dropped from the system
REM   going to 9i release 2. These objects are completely obsolete
REM   and need to be removed from the database for the 9i2 release.
REM
REM  NOTES
REM
REM
REM  MODIFIED   (MM/DD/YY)
REM   dbardwel   01/25/02 - dbardwel_txn101624
REM   dbardwel   01/24/02 - Created.


REM Remove one package and its package body
drop package olapsys.CWM$OLAP$SERVER$LIST
/

REM Remove two views 
drop view olapsys.ALL$OLAP_CHILD_INSTANCES_LIST
/
drop view olapsys.DBA$OLAP_CHILD_INSTANCES_LIST
/

REM Remove two public synonyms
drop public synonym ALL_OLAP_CHILD_INSTANCES_LIST
/
drop public synonym DBA_OLAP_CHILD_INSTANCES_LIST
/

REM Drop 2 obsolete tables
drop table olapsys.OS_CHILD_INSTANCES
/
drop table olapsys.OS_OSA_PRIVILEGES
/