Rem
Rem u0800050.sql
Rem $Header: u0800050.sql 15-jun-98.10:48:21 mkamath Exp $
Rem
Rem u0800050.sql
Rem
Rem  Copyright (c) Oracle Corporation 1998. All Rights Reserved.
Rem
Rem    NAME
Rem      u0800050.sql - upgrade Oracle RDBMS from 8.0.5 to the new release
Rem
Rem    DESCRIPTION
Rem
Rem     This script is to be used for upgrading an 8.0.5 database to the
Rem     new release.  This script provides a direct upgrade path from 8.0.5
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 c0800050.sql:
Rem			This performs all necessary dictionary 
Rem			upgrade to bring the db from 8.0.5 to the
Rem			new release.
Rem        STAGE 4: call a0800050.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    rshaikh     06/17/98 - rework upgrade:
Rem			      * move all critical stmts 
Rem				into i0800050.sql
Rem			      * move all non-anonymous block stmts 
Rem				into c0800050.sql
Rem			      * move all anonymous block stmts 
Rem				into a0800050.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 =========================================================================

@@c0800050

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

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

@@a0800050

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