Rem
Rem $Header: c0800040.sql 17-jun-98.13:57:16 rshaikh Exp $
Rem
Rem c0800040.sql
Rem
Rem  Copyright (c) Oracle Corporation 1998. All Rights Reserved.
Rem
Rem
Rem    NAME
Rem      c0800040.sql - upgrade Oracle RDBMS from 8.0.4 to the new release
Rem
Rem    DESCRIPTION
Rem
Rem	 Put any dictionary related changes here (ie-create, alter, 
Rem    	 update,...).  DO NOT put PL/SQL modules in this script.  
Rem	 If you must upgrade using PL/SQL, put the module in a0800040.sql
Rem	 as catalog.sql and catproc.sql will be run before a0800040.sql
Rem	 is invoked.
Rem
Rem	 This script is called from u0800040.sql and c0800030.sql
Rem
Rem      This script performs the upgrade in the following stages:
Rem        STAGE 1: upgrade from 8.0.4 to 8.0.5 (nothing to be done here, tho')
Rem        STAGE 2: upgrade from 8.0.5 to the new release;
Rem                 call c0800050.sql to do this.
Rem
Rem    NOTES
Rem
Rem      * This script needs to be run in the new release's environment
Rem        (after installing the release to which you want to upgrade).
Rem
Rem      * You must be connected as INTERNAL to run this script.
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    rshaikh     06/17/98 - rework upgrade:
Rem			      * move all non-anonymous block stmts from
Rem				u0800040.sql here
Rem    usundara    06/03/98 - rework upgrade/downgrade/migration scripts:
Rem                           * merge from 8.0.5 branch
Rem                           * for 8.1.3: replace calls to catalog and catproc
Rem                             with call to u0800050.sql
Rem    usundara    04/11/98 - upgrade from 8.0.4 to new 8.0.x release
Rem    usundara    04/11/98 - Created
Rem

Rem =========================================================================
Rem BEGIN STAGE 1: upgrade from 8.0.4 to 8.0.5
Rem =========================================================================

Rem --- NOTHING TO BE DONE HERE

Rem =========================================================================
Rem END STAGE 1: upgrade from 8.0.4 to 8.0.5
Rem =========================================================================

Rem =========================================================================
Rem BEGIN STAGE 2: upgrade from 8.0.5 to the new release
Rem =========================================================================

Rem call c0800050; note that this calls catalog and catproc.
Rem
@@c0800050.sql

Rem =========================================================================
Rem END STAGE 2: upgrade from 8.0.5 to the new release
Rem =========================================================================

Rem *************************************************************************
Rem END c0800040.sql
Rem *************************************************************************

