Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Upgrade 8.0.5 to 8.1.6

RE: Upgrade 8.0.5 to 8.1.6

From: Jeremiah Wilton <>
Date: Wed, 21 Nov 2001 17:21:31 -0800
Message-ID: <>

Correct me if I am wrong, but you don't migrate from 8.0 to 8.1. You just start up on the new binaries and run u080005.sql or something. The migration utility is for 7.x to 8.x. Read the manual. Re-creating the database, then exporting and importing will take much longer than just running a couple scripts.

If it is reverting that you are worried about, take an online backup before you upgrade.

Jeremiah Wilton

On Wed, 21 Nov 2001, Barbara Baker wrote:

> If you track down the 8i migration manual, here's a comparison chart that
> shows the benefits of export/import versus migration (using the uxxxx
> scripts).
> It depends on your database configuration, but yes, the main benefit in
> using migration is speed. If your database is relatively small, exp/imp
> should be no problem. If it's large, the difference betwen exp/imp and
> migration will be significant.
> >From: "Ed" <>
> >
> >Yes, I agree 100%, but people here are concerned that upgrading will
> >"break"
> >the database, and we have to QUICKLY move everything over to 8.1.6. (Long
> >story). What I was really after in my original question was: why is the
> >upgrade script a better solution than just recreating the tablespaces in
> >8.1.6 and importing from an export of the old database? Does it just save
> >time? Is there a downside to using export/import this way?
-- Please see the official ORACLE-L FAQ: -- Author: Jeremiah Wilton INET: Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Received on Wed Nov 21 2001 - 19:21:31 CST

Original text of this message