Rem
Rem $Header: d0801050.sql 22-sep-99.12:29:54 rshaikh Exp $
Rem
Rem d0801050.sql
Rem
Rem  Copyright (c) Oracle Corporation 1999. All Rights Reserved.
Rem
Rem    NAME
Rem      d0801050.sql -  downgrade Oracle RDBMS from current release to 8.1.5
Rem
Rem    DESCRIPTION
Rem
Rem      See the README file and the Oracle Migration book for details.
Rem
Rem      This script is to be used for downgrading your database from the
Rem      current release you have installed to the 8.1.5 release.  This
Rem      script provides a direct downgrade path from your current installed
Rem      release to the 8.1.5 release.
Rem
Rem      This script performs the downgrade in the following stages:
Rem        STAGE 1: downgrade the dictionary
Rem        STAGE 2: downgrade standard.sql
Rem
Rem    NOTES
Rem	 * This script must be run using SQL*PLUS
Rem      * This script needs to be run in the current release's environment
Rem        (before installing the release to which you want to downgrade).
Rem
Rem      * You must be connect as INTERNAL to run this script.
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    rshaikh     09/22/99 -
Rem    rshaikh     09/22/99 - bug 994326: move to e0801050.sql
Rem    smuthuli    08/30/99 - drop dba_?mt_free_space, dba_?mt_used_extent: 
Rem                              merge from 817
Rem    rshaikh     08/02/99 - downgrade datetime sys types
Rem    attran      07/13/99 - PIOT: set TAB$/pctused to ZERO.
Rem    anithrak    08/06/99 - Add V$BUFFER_POOL_STATISTICS
Rem    rshaikh     07/19/99 - remove views that depend on fixed views
Rem    evoss       07/12/99 - v$hs_parameter views                             
Rem    kdias       07/01/99 - nested MJV and MAV1 MVs -> complex MVs  
Rem    cmlim       06/11/99 - lrg33357: drop gv_$loadistat, v_$loadistat
Rem    amganesh    06/02/99 - drop new 8.1.6 synonyms
Rem    nvishnub    04/19/99 - Drop index on expdepobj$ for parent object.
Rem    rshaikh     02/12/99 - Created
Rem

Rem =========================================================================
Rem BEGIN STAGE 1: downgrade 
Rem =========================================================================

@@e0801050

Rem =========================================================================
Rem END STAGE 1: downgrade 
Rem =========================================================================

Rem =========================================================================
Rem BEGIN STAGE 2: downgrade standard
Rem =========================================================================

@@utlstddw

Rem =========================================================================
Rem END STAGE 2: downgrade standard
Rem =========================================================================

Rem *************************************************************************
Rem END d0801050.sql
Rem *************************************************************************
