Re: 8.0.5 to 8.1.7 migration

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Mon, 23 Sep 2002 22:12:55 +0100
Message-ID: <3d8f8969_3@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 Mon Sep 23 2002 - 16:12:55 CDT