Rem
Rem $Header: mgw/src/plsql/admin/mgwe112.sql /mgw_main/1 2009/10/08 15:03:05 jleinawe Exp $
Rem
Rem mgwe112.sql
Rem
Rem Copyright (c) 2009, Oracle and/or its affiliates. All rights reserved. 
Rem
Rem  NAME
Rem    mgwe112.sql - downgrade MGW component to 11.2.0
Rem
Rem  DESCRIPTION
Rem    Reverts data dictionary for MGW component to the 11.2.0 release.
Rem    This script is run in the context of the "new" (12.1.0) database.
Rem
Rem  NOTES
Rem    This script must be run AS SYSDBA.
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    jleinawe    10/05/09 - Created
Rem
Rem ==========================================================================

Rem For NNN+2 to NNN (12.2 to 11.2) downgrade, first perform the
Rem NNN+2 to NNN+1 (12.2 to 12.1) downgrade actions
rem @@mgwe121

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

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

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

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

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