Edit D:\app\Administrator\product\11.2.0\dbhome_1\mgw\admin\mgwdbmig.sql
Rem Rem $Header: mgw/src/plsql/admin/mgwdbmig.sql /mgw_main/8 2008/08/24 09:37:36 chall Exp $ Rem Rem mgwdbmig.sql Rem Rem Copyright (c) 2002, 2008, Oracle. All rights reserved. Rem Rem NAME Rem mgwdbmig.sql - MGW component migration script Rem Rem DESCRIPTION Rem Migration script to upgrade the Messaging Gateway (MGW) component. Rem This script is called from $ORACLE_HOME/rdbms/admin/cmpdbmig.sql Rem in context of the "new" database during a RDBMS upgrade. Rem Rem NOTES Rem This script must be run AS SYSDBA. Rem Rem MGW scripts located at: $ORACLE_HOME/mgw/admin Rem Rem MGW first available starting with RDBMS 9.0.1. Rem Rem For direct 9.0.1->10.0.0 upgrade, a registry entry will have been Rem added for MGW component, but with the validation routine set to null. Rem This script should specify one when it calls dbms_registry.upgrading. Rem The MGW registry entry is added by dbms_registry_sys.populate Rem (called by $OH/rdbms/a0900010.sql). Rem Rem MODIFIED (MM/DD/YY) Rem chall 08/24/08 - 11.2 upgrade Rem chall 06/15/06 - use RDBMS version for MGW component version Rem chall 03/30/06 - add check for upgrade from 10.2.0 Rem chall 09/17/04 - bugfix 3895383; reload dblink and library objects Rem chall 05/14/04 - add 10gR2 migration hooks Rem chall 11/26/02 - call dbms_registry.check_server_instance Rem chall 10/31/02 - upgrade to 10i Rem chall 02/07/02 - chall_bug-2218028 Rem chall 02/07/02 - Created Rem Rem ========================================================================== whenever sqlerror exit execute dbms_registry.check_server_instance whenever sqlerror continue -- specify validate routine since one not yet set if 9.0.1->10.1.0 upgrade execute - dbms_registry.upgrading('MGW', 'Messaging Gateway', 'mgwi_reg.validate_mgw') -- set up component script file variable COLUMN :script_name NEW_VALUE comp_file NOPRINT VARIABLE script_name VARCHAR2(60) -- decide which dictionary upgrade script to run BEGIN IF substr(dbms_registry.version('MGW'),1,5) = '9.0.1' THEN :script_name := '@mgwu901.sql'; ELSIF substr(dbms_registry.version('MGW'),1,5) = '9.2.0' THEN :script_name := '@mgwu920.sql'; ELSIF substr(dbms_registry.version('MGW'),1,6) = '10.1.0' THEN :script_name := '@mgwu101.sql'; ELSIF substr(dbms_registry.version('MGW'),1,6) = '10.2.0' THEN :script_name := '@mgwu102.sql'; ELSIF substr(dbms_registry.version('MGW'),1,6) = '11.1.0' THEN :script_name := '@mgwu111.sql'; ELSE :script_name := dbms_registry.nothing_script; END IF; END; / -- run the dictionary upgrade script SELECT :script_name FROM DUAL; @&comp_file -- reload database link and library objects @@mgwlib -- create new tables (noop for existing tables) @@mgwtable -- load current package specs, type bodies, package bodies, views -- standard/common "post-install" tasks @@mgwlod execute dbms_registry.upgraded('MGW') execute mgwi_reg.validate_mgw Rem === End file: mgwdbmig.sql ===============================================
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de