Edit D:\app\Administrator\product\11.2.0\dbhome_1\mgw\admin\mgwu901.sql
Rem Rem $Header: mgwu901.sql 01-nov-2002.16:42:47 chall Exp $ Rem Rem mgwu901.sql Rem Rem Copyright (c) 2002, Oracle Corporation. All rights reserved. Rem Rem NAME Rem mgwu901.sql - MGW upgrade script from Release 9.0.1 Rem Rem DESCRIPTION Rem Upgrade Messaging Gateway from MGW/RDBMS Release 9.0.1 to 9.2.0. Rem Rem NOTES 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 9.0.1 database in which the MGW component had been loaded. Rem Rem The version of this script used for 10.0.0 (and subsequent) releases Rem is drastically different than that used for 9.2.0 release. For 10.0.0 Rem release, the MGW migration scripts were altered to be in tune with Rem suggested guidelines. Rem Rem MODIFIED (MM/DD/YY) Rem chall 11/01/02 - 10iR1 upgrade Rem chall 02/15/02 - reference dbms_registry release_version constant. Rem chall 02/07/02 - chall_bug-2218028 Rem chall 02/07/02 - Created Rem Rem ========================================================================== -- For 9.0.1 -> 9.2.0 upgrade: -- a) One internal package was dropped. It had no synonym. -- b) There are no other dictionary changes that should be done by a -- component "u" script, according to component guidelines. -- - No tables were modified or altered. No new tables were added. -- - No type specs were modified or altered. No new types were added. -- - No additional privilege grants are needed. -- drop obsolete packages drop package sys.mgwi_mesg; Rem ======================================================================== Rem Chain to component's next "u" script Rem ======================================================================== @@mgwu920 Rem === End file: mgwu901.sql ================================================
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de