Rem
Rem d0800030.sql
Rem
Rem  Copyright (c) Oracle Corporation 1997, 1998, 1999. All Rights Reserved.
Rem
Rem    NAME
Rem      d0800030.sql - downgrade Oracle RDBMS from current release to 8.0.3
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.0.3 release.  This
Rem      script provides a direct downgrade path from your current installed
Rem      release to the 8.0.3 release.
Rem
Rem      This script performs the downgrade in the following stages:
Rem        STAGE 1: downgrade dictionary
Rem        STAGE 2: downgrade standard.sql
Rem
Rem    NOTES
Rem
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 - bug 994326: move to e0800030.sql
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                             - change name cat8004d.sql->d08000030.sql
Rem                             - call d0800040
Rem    wuling      11/17/97 - drop dbms_pitr and dbms_pickler packages
Rem    ato         11/15/97 - drop rowcache_parent rowcache_subordinate
Rem    wuling      11/14/97 - drop v$ and gv$recovery_progress
Rem    ato         11/14/97 - add drop public synonyms
Rem    skaluska    11/14/97 - Take care of x$,v$ views
Rem    tlahiri     11/14/97 - drop (gv|v)$(current|recent)_bucket
Rem    mcoyle      11/14/97 - Add V$lock_activity and gv$lock_activity
Rem    ato         11/13/97 - 804->803 downgrade
Rem    ato         11/13/97 - Created
Rem


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

@@e0800030

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 d0800030.sql
Rem *************************************************************************

