RE: Upgrade 8.0.5 to 8.1.6

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
http://www.speakeasy.net/~jwilton

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" <mrclark_at_xnet.com>

> >

> >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: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

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: ListGuru_at_fatcity.com (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).