Re: 8.0.5 to 8.1.7 migration

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 24 Sep 2002 23:25:55 +1000
Message-ID: <VyZj9.39159$g9.113738@newsfeeds.bigpond.com>

Hi again Paul,

You've answered the question yourself when you said 'time permitting.

The advantage of performing an upgrade via the upgrade script is that it's potentially much quicker than the export/import method. Note that the first backup I mentioned is not optional (unless you feel lucky) so that needs to be considered but it's still should be substantially quicker. You also don't have issues with a "second" database to deal with.

The advantages of using export/import is you use a utility that is both familiar and dear to our hearts and that at the end of the process, you have a nice new, defragmented, cleaned up database. If you're going to upgrade, it's a good opportunity to clean things up. The disadvantage is that the upgrade process will take longer.

I have absolutely no issue with you preferring the export/import method as it's obviously the most appropriate method at your site. However it time doesn't permit, then the upgrade script is potentially the way to go.

Cheers

Richard
"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:3d8f8969_3_at_mk-nntp-1.news.uk.worldonline.com...
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:ubEj9.38492$g9.111311_at_newsfeeds.bigpond.com...
> > Hi Oraclion,
> >
> > Just perform a basic upgrade which entails installing the software (in
> it's
> > own home directory), shutting down and backing up the 8.0.5 database,
> > changing the environment variables as appropriate for 8i (eg.
> ORACLE_HOME),
> > changing the parameter file as appropriate for an 8i instance, startup
the
> > database in restrict mode, run the upgrade script (U0800050.sql),
shutdown
> > and backup again (optional I guess).
> >
> > Other options are to use the GUI Migration Assistant (that basically
> > performs the above) or possibly to database export/import.
> >
> > Cheers
> >
> > Richard
> > "Oraclion" <inferno74_at_caramail.com> wrote in message
> > news:ammq1m$498$1_at_wanadoo.fr...
> > > Hi
> > >
> > > What is the best way for migration of 8.0.5 to 8.1.7
> > >
> > > Thanks
> > > Oraclion

>

> Richard,

>
> I don't want to confuse the issue, and your advice is as as ever
excellent,
> but (time permitting), wouldn't you go for export/import as the first
> option? I would.

>

> Cheers,
> Paul

>
>
>

Received on Tue Sep 24 2002 - 08:25:55 CDT