Rem
Rem $Header: e0800040.sql 22-sep-99.10:39:27 rshaikh Exp $
Rem
Rem e0800040.sql
Rem
Rem  Copyright (c) Oracle Corporation 1999. All Rights Reserved.
Rem
Rem    NAME
Rem      e0800040.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
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.0.4 release.  This
Rem      script provides a direct downgrade path from your current installed
Rem      release to the 8.0.4 release.
Rem
Rem      This script performs the downgrade in the following stages:
Rem        STAGE 1: perform the downgrade from the current release to 8.0.5
Rem                 call e0800050.sql to do this.
Rem        STAGE 2: perform the downgrade from 8.0.5 to 8.0.4
Rem
Rem    NOTES
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 - Created
Rem    ncramesh    08/04/98 - change for sqlplus
Rem    usundara    06/03/98 - rework upgrade/downgrade/migration scripts:
Rem                           * merge from 8.0.5
Rem                           * call d0800050.sql to downgrade from
Rem                             current release to 8.0.5 before doing
Rem                             the downgrade to 8.0.4
Rem    usundara    04/13/98 - downgrade from current release to 8.0.4
Rem    usundara    04/13/98 - Created
Rem


Rem =========================================================================
Rem BEGIN STAGE 1: downgrade from the current release to 8.0.5
Rem =========================================================================

@@e0800050.sql

Rem =========================================================================
Rem END STAGE 1: downgrade from the current release to 8.0.5
Rem =========================================================================

Rem =========================================================================
Rem BEGIN STAGE 2: downgrade from 8.0.5 -> 8.0.4
Rem =========================================================================

Rem =========================================================================
Rem BEGIN utlref related downgrade
Rem       (utl_ref was not part of default installation in 8.0.4)
Rem =========================================================================

drop public synonym UTL_REF
/
drop package UTL_REF
/
drop library DBMS_UTL_REF_LIB
/

Rem =========================================================================
Rem END utlref related downgrade
Rem =========================================================================

Rem =========================================================================
Rem END STAGE 2: downgrade from 8.0.5 to 8.0.4
Rem =========================================================================

Rem =========================================================================
Rem NOTES:
Rem If you had manually installed UTL_REF in 8.0.4 prior to upgrading, then
Rem you'll need to reinstall it after the downgrade.
Rem =========================================================================

Rem *************************************************************************
Rem END e0800040.sql
Rem *************************************************************************


