Re: Upgrade 8.0.5 to 8.1.6

Yes, Oracle actually calls it an upgrade.

I think the point everyone wanted to make though was it's not a good idea to just start your database with the 8.1 binaries.

Jared

On Wednesday 21 November 2001 16:40, Jeremiah Wilton wrote:
> 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: Jared Still
  INET: jkstill_at_cybcon.com

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).