Rem
Rem $Header: mgw/src/plsql/admin/mgwu111.sql /mgw_main/1 2008/08/24 09:37:36 chall Exp $
Rem
Rem mgwu111.sql
Rem
Rem Copyright (c) 2008, Oracle. All rights reserved.
Rem
Rem  NAME
Rem    mgwu111.sql - MGW component upgrade script from 11.1.0 (to 11.2.0)
Rem
Rem  DESCRIPTION
Rem    This script must be run AS SYSDBA.
Rem
Rem    This script is intended to be run during component upgrade process;
Rem    typically from mgwdbmig.sql. It should only be called when upgrading
Rem    a 11.1.0 database in which the MGW component is currently loaded.
Rem
Rem    Messaging Gateway agent must be shut down before running this script.
Rem
Rem  NOTES
Rem    TOID Note: Starting with RDBMS 10R1, a fixed OID is assigned for 
Rem    every new MGW type, rather than having one automatically assigned by
Rem    the database. Note however, for any 9.x to NNN upgrade, we will wind
Rem    up with a mixture, fixed ids for any new types but old generated ids 
Rem    for existing types. It is something that we (and the user) has to deal
Rem    with. OJMS and likely other components face the same issue if they
Rem    did not use the OID clause from the start.
Rem
Rem  MODIFIED   (MM/DD/YY)
Rem  chall       08/24/08 - Created
Rem
Rem ==========================================================================

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

Rem ========================================================================
Rem Chain to component's next "u" script
Rem ========================================================================

Rem For next release, we will need to chain to mgwuNNN+1 script
rem @@mgwu112

Rem === End file: mgwu111.sql ================================================