RE: Upgrade 8.0.5 to 8.1.7.3 (fwd)

Yes, exp/imp cleans up a lot of garbage. I always use this method.

-----Original Message-----
Sent: Wednesday, April 17, 2002 3:38 PM
To: Multiple recipients of list ORACLE-L

An upgrade can be seen as a rare chance to do all these things, if you choose exp/imp method. That's what John is referring to.

LK

> -----Original Message-----
> From: Jeremiah Wilton [SMTP:jwilton_at_speakeasy.net]
> Sent: Wednesday, April 17, 2002 5:12 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Upgrade 8.0.5 to 8.1.7.3 (fwd)
>
> On Wed, 17 Apr 2002, John Weatherman wrote:
>
> > Clean up fragmentation/chaining, change block size at the same time,
> > in my current case, chage hardware platform...
> >
> > All sorts of reasons. :)
>
> What do those things have to do with an upgrade?
>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>
> > -----Original Message-----
> > On Wed, 17 Apr 2002, Browett, Darren wrote:
> >
> > > The previous DBA, also used the export/import method, and is the
> method
> > > I am most likely going to use.
> >
> > Can someone explain why anyone would opt for export/import as a path
> > to do an 8.0 to 8.1 upgrade? Doesn't the basic upgrade just consist
> > of starting the instance on the new ORACLE_HOME and running an upgrade
> > script? Why would someone undergo the disruption and complexity of a
> > full export/import when you can just leave the data where it is?
>
>
> --
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Koivu, Lisa
  INET: lisa.koivu_at_efairfield.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Wong, Bing
  INET: bing.wong_at_IngramMicro.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).