rem 
Rem  Copyright (c) 1992, 1996, 1997, 1998 by Oracle Corporation 
Rem
Rem    NAME
Rem      u0703040.sql - additional upgrade script to be run when migrating a
Rem                     version 7 database.
Rem
Rem    DESCRIPTION
Rem
Rem      Additional upgrade script to be run during the migration of a
Rem      7.3.x database to the new release.
Rem
Rem      * This script needs to be run as a step in the
Rem        "Migration Steps in the Version 8 Environment".
Rem      * See the "Oracle8 Migration book for release 8.1" for more details.
Rem
Rem      The upgrade is partitioned into the following 4 stages:
Rem        STAGE 1: call i0800050.sql:
Rem			This loads all tables that are necessary
Rem			to perform basic sql commands.
Rem	   STAGE 2: call utlip.sql to invalidate views, procedures, packages...
Rem        STAGE 3: call c0703040.sql:
Rem			This performs all necessary dictionary 
Rem			upgrade to bring the db from post 7.3.x to the
Rem			new release.
Rem        STAGE 4: call a0703040.sql:
Rem			This performs all necessary upgrade using
Rem			anonymous blocks.
Rem
Rem    RETURNS
Rem 
Rem    NOTES
Rem	 WARNING:  DO NOT TOUCH THIS FILE!!!!! PUT ANY NECESSARY
Rem		   CHANGES INTO i08000x0.sql, c08000x0.sql, or
Rem		   a08000x0.sql for current upgrade
Rem      You must connect internal to run this script
Rem  
Rem    MODIFIED   (MM/DD/YY)
Rem			      * move all critical stmts 
Rem				into i0800050.sql
Rem			      * move all non-anonymous block stmts 
Rem				into c0703040.sql
Rem			      * move all anonymous block stmts 
Rem				into a0703040.sql

Rem =========================================================================
Rem BEGIN STAGE 1: load mandatory tables - please see i0800050.sql
Rem		for definition of what a mandatory table is
Rem =========================================================================

@@i0800050

Rem =========================================================================
Rem END STAGE 1: load mandatory tables
Rem =========================================================================

Rem =========================================================================
Rem BEGIN STAGE 2: invalidate all procedure, packages, functions, trig, typs
Rem =========================================================================

Rem -- NOTHING TO BE DONE HERE since it is already done in migrate.bsq

Rem =========================================================================
Rem END STAGE 2: invalidate all procedure, packages, functions, trig, typs
Rem =========================================================================

Rem =========================================================================
Rem BEGIN STAGE 3: dictionary upgrade
Rem  ***catalog.sql and catproc.sql are run at the end of c08000x0.sql
Rem =========================================================================

@@c0703040

Rem =========================================================================
Rem END STAGE 3: dictionary upgrade
Rem =========================================================================


Rem =========================================================================
Rem BEGIN STAGE 4: upgrade using anonymous pl/sql blocks
Rem =========================================================================

@@a0703040

Rem =========================================================================
Rem END STAGE 4: upgrade using anonymous pl/sql blocks
Rem =========================================================================