rem 
Rem  Copyright (c) 1992, 1996, 1997, 1998 by Oracle Corporation 
Rem
Rem    NAME
Rem      u0800040.sql - upgrade Oracle RDBMS from 8.0.4 to the new release
Rem
Rem    DESCRIPTION
Rem
Rem      This script is to be used for upgrading an 8.0.4 database to the
Rem      new release.  This script provides a direct upgrade path from 8.0.4
Rem      to the new Oracle release.
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 c0800040.sql:
Rem			This performs all necessary dictionary 
Rem			upgrade to bring the db from 8.0.4 to the
Rem			new release.
Rem        STAGE 4: call a0800040.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 c0800040.sql
Rem			      * move all anonymous block stmts 
Rem				into a0800040.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 =========================================================================

@@utlip

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 =========================================================================

@@c0800040

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


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

@@a0800040

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