Rem
Rem d0800050.sql
Rem
Rem  Copyright (c) Oracle Corporation 1997, 1998, 1999. All Rights Reserved.
Rem
Rem    NAME
Rem      d0800050.sql - downgrade Oracle RDBMS from current release to 8.0.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.0.5 release.  This
Rem      script provides a direct downgrade path from your current installed
Rem      release to the 8.0.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 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 e0800050.sql
Rem       rshaikh  08/18/99 - lrg34212: recreate dbms_utility
Rem       wesmith  07/23/99 - Bug 928696: metadata of downgraded aggregate and 
Rem                           join view snapshots is incorrect
Rem       rshaikh  07/15/99 - change catspaced to catspacd
Rem       rshaikh  03/10/99 - fix Y2K problem in snap_reftime$
Rem       bnainani 01/07/99 - remove drop dbms_aqin-move to d080103
Rem       bnainani 12/22/98 - drop dbms_aqin during downgrade
Rem       rshaikh  12/16/98 - remove more privileges
Rem       rshaikh  12/04/98 - recompile types on downgrade
Rem       rshaikh  10/26/98 - remove drop tables
Rem       tlahiri  11/09/98 - Add (g)v_instance_recovery views
Rem       rshaikh  09/09/98 - remove sys types downgrade;
Rem			      don't drop ustats$ (needed by 8.1.4)
Rem       ncramesh 08/04/98 - change for sqlplus
Rem       rshaikh  07/21/98 - call d0801030.sql
Rem				move outline
Rem       rshaikh  07/31/98 - remove obsolete fixed view info
Rem       rshaikh  07/21/98 - remove 8.1.3 sys privs
Rem       liwong   07/21/98 - Add repcat$_repcat.flag                      
Rem       jingliu  07/13/98 - downgrade for snap_reftime$             
Rem       rwessman 07/09/98 - Removed proxy# column from i_audit index         
Rem       smuralid 07/10/98 - downgrade system type tables                     
Rem       rshaikh  06/25/98 - fix second downgrade
Rem       ato      06/25/98 - AQ downgrade fix
Rem       rshaikh  06/18/98 - add type downgrade
Rem       arhee    06/15/98 - change name for db scheduler
Rem       ato      06/12/98 - remove queue objects
Rem       rshaikh  06/11/98 - reset compatibility after dropping atemptab
Rem       mkamath  06/10/98 - Adding downgrade for AQ Propagation Scheduling
Rem       akalra   06/09/98 - catschedno.sql -> catrmno.sql
Rem       hasun    06/08/98 - Snapshot/Materialized View downgrade             
Rem       nbhatt   06/08/98 - drop AQ queue table affinites table
Rem       jfinnert 06/05/98 - Reflect changes for summary mgmt
Rem       gclaborn 06/04/98 - Separate new export tables
Rem       usundara 06/03/98 - rework upgrade/downgrade/migration scripts:
Rem                           * change name c813d805.sql --> d0800050.sql
Rem                           * fix comments
Rem                           * add changes from RSHAIKH
Rem       bgoyal   05/19/98 - downgrade script for temporary tables            
Rem       gclaborn 05/19/98 - Add drop of export tables for proc. obj support
Rem       rshaikh  05/18/98 - remove proxy
Rem       svivian  05/07/98 - delete OUTLN tuples from expact
Rem       rshaikh  05/01/98 - add catspace.sql downgrade, remove type$ column
Rem		              fix sys priv statement
Rem       liwong   04/27/98 - set repobject.status to ERROR for $RP/$RL
Rem       rshaikh  04/20/98 - drop sys priv, aud opts, trigger, java, mls,
Rem       mdepledg 04/19/98 - invalidate protected bitmap indexes              
Rem       akalra   04/17/98 - Downgrade for db scheduler
Rem       clei     04/08/98 - Remove rls$ for downgrade
Rem       dmwong   04/03/98 - drop context support in pre-8.1                  
Rem       amozes   03/30/98 - drop package dbms_stats                          
Rem       pravelin 04/01/98 - Delete HS fixed views
Rem       jfeenan  03/24/98 - Remove sumdelta$ and sumdep$ along with their ind
Rem       jfeenan  03/20/98 - Add downgrade information for summaries and dimen
Rem       jstamos  02/27/98 - flavor support                                   
Rem       mmonajje 01/26/98 - Created 8.1.3 to 8.0.5 downgrade script
Rem

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

@@e0800050

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