Rem
Rem $Header: mgwe901.sql 07-feb-2002.17:47:08 chall Exp $
Rem
Rem mgwe901.sql
Rem
Rem Copyright (c) 2002, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      mgwe901.sql - MGW downgrade script
Rem
Rem    DESCRIPTION
Rem      Downgrade Messaging Gateway from MGW/RDBMS Release 9.2.0 to 9.0.1.
Rem
Rem    NOTES
Rem      This script must be run as SYSDBA.
Rem
Rem      This script should be run during the component downgrade process,
Rem      in context of the 9.2.0 database.
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    chall       02/07/02 - chall_bug-2218028
Rem    chall       02/07/02 - Created
Rem
Rem ==========================================================================

-- indicate downgrade in progress
execute dbms_registry.downgrading('MGW');

-- drop packages added for 9.2.0
drop package mgwi_reg;

-- indicate downgrade is done
execute dbms_registry.downgraded('MGW', '9.0.1.0.0');