> -----Original Message-----
> From: Leslie Lu [mailto:[EMAIL PROTECTED]]
>
> 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
