Rem
Rem $Header: mgw/src/plsql/admin/mgwe111.sql /mgw_main/1 2008/08/24 09:37:36 chall Exp $
Rem
Rem mgwe111.sql
Rem
Rem Copyright (c) 2008, Oracle. All rights reserved.
Rem
Rem  NAME
Rem    mgwe111.sql - downgrade MGW component to 11.1.0
Rem
Rem  DESCRIPTION
Rem    Reverts data dictionary for MGW component to the 11.1.0 release.
Rem    This script is run in the context of the "new" (11.2.0) database.
Rem
Rem  NOTES
Rem    This script must be run AS SYSDBA.
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    chall       08/24/08 - Created
Rem
Rem ==========================================================================

Rem For NNN+2 to NNN (11.3 to 11.1) downgrade, first perform the
Rem NNN+2 to NNN+1 (11.3 to 11.2) downgrade actions
rem @@mgwe112

Rem Now, perform the 11.2 to 11.1 downgrade actions
execute dbms_registry.downgrading('MGW');

Rem ========================================================================
Rem No database changes for MGW component for 11.2.0 release.
Rem No downgrade actions needed for MGW other than registry.
Rem ========================================================================

rem ========================================================================
rem Downgrade complete
rem ========================================================================

execute dbms_registry.downgraded('MGW', '11.1.0');

Rem === End file: mgwe111.sql ================================================