RE: database degrade ???

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 18 Oct 2001 15:31:38 -0700
Message-ID: <F001.003AF5B5.20011018153526@fatcity.com>

> -----Original Message-----
> From: Leslie Lu [mailto:leslie_y_lu_at_yahoo.com]
>
> We installed 815, 817 on Sun 5.6.  There is an 817
> database, and developers requested to build an exactly
> same database but at 815 level. 
>
> I don't think I can copy 817's backup files and create
> a 815 db, since the backup already has 817
> characteristics.  Is there a way to do degrade?
>
> If I create an 815 db, and do an export/import, how do
> I make sure the dmp from 817 only have 815
> characteristics.  Full db export won't work, is it?
> And does schema export has nothing to do with Oracle
> version, if so, I can use schema dmp file.

N.B. I have not tried the procedure below, we decided against the downgrade, but I was told that this note relates to Oracle 8.1.7

Oracle Metalink Note: 120912.1

   
Doc ID:  Note:120912.1
Subject:  Downgrade Scripts Oracle 8.X -> 8.X Type:  BULLETIN
Status:  PUBLISHED
 Content Type:  TEXT/PLAIN
Creation Date:  28-SEP-2000
Last Revision Date:  10-NOV-2000
 

PURPOSE

---

  This note is purely a list of the scripts to run moving between 
  Oracle 8 versions only.  It is intended to be a quick reference
  guide to script names only.


  It is important to read current Oracle8 Server Migration Guide and

  the README.DOC and READMEMIG.DOC files supplied with the Oracle   release that you wish to downgrade to.

Important

---

  Before downgrading or changing <Parameter:COMPATIBLE> it is advisable to:

        o Make sure there are no PENDING transactions;
        o Shut down the database cleanly;
        o Take a full cold backup;

Downgrade Scripts

---

Downgrading To                           Run Script 
      
      8.1.5                              d0801050.sql
 
      8.1.4                              d0801040.sql
 
      8.1.3                              d0801030.sql

 

      8.1.2                              Not supported


      8.1.1                              Not supported

 

      8.0.6                              d0800060.sql 


      8.0.5                              d0800050.sql 


      8.0.4S                             Not supported

 

      8.0.4                              d0800040.sql 


      8.0.3                              d0800030.sql 


      8.0.2                              Not supported


      8.0.1                              Not supported


  Note: If the release to which you are downgrading is not included, then see

        the README files in the new installation for the correct downgrade         script to run. 

The following are notes about running the script:

---

• You must use the version of the script included with the release from which   you are downgrading.
• You must run the script in the environment of the release from which you are   downgrading.
• You only need to run one script, even if your downgrade spans several   releases.  For example, if you are downgrading to release 8.0.3, then you   need to run only d0800030.sql.
• If you are using mutually referencing types, then downgrading to release   8.0.3 or 8.0.4.0 is not supported. 

If you encounter any problems when you run the script, or any of the scripts in the remaining steps, then correct the causes of the problems and rerun the script.

RELATED DOCUMENTS

---

Oracle8i Migration Guide, Chapter:  Downgrading to an Older Version 8 Release Received on Thu Oct 18 2001 - 17:31:38 CDT