Cleaning up before upgrades / migrations; avoiding upgrade proble ms

Hi,

We are preparing to upgrade our databases here from 7.3.4. to 8.1.6..

Do you have any suggestions re. re-organization, "cleaning up" before the migration is done, or just after it is done, and before I release the servers to the developers and end users? If you have done this type of upgrade before, any problems encountered?

e.g. separating indexes and tables, right now they are all lumped in the same tablespace. Ensuring that extent sizes are appropriate.

I intend to use export / import to do the transition instead of the migration utility. I am testing that today with a few schemas on NT, will test it again later with full exports / imports on Tru64 when we receive our new Digital servers.

TIA
Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada

> -----Original Message-----
> From: Michael Netrusov
> Sent: Wednesday, March 21, 2001 12:58 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: EMC TimeFinder, and EMC TimeFinder vs Hot Standby
>
> Yosi,
>
> Hot standby db protects you from the data corruption. Any kind of
> mirroring does not - it's just a copy.
>
> HTH,
> Michael Netrusov,
> www.atelo.com
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, March 21, 2001 06:10
>
>
> > Hi All,
> >
> > Can anyone give me a quick (free!) lesson on the concepts
> > behind timefinder? How does this differ from their standard
> > SRDF which (to my understanding) is to split the mirror and
> > back it up.
> >
> > Or is it that they add their BCV stuff to SRDF so you can
> > access the data while the mirror is split? Then, is it like
> > a Hot Standby DB?
> >
> > (We used to get something in high school that was some sort
> > of mixture between fish and potatoes, and we could never
> > figure out if it was fish or if it was potatoes, or both,
> > or neither. Somehow, this is reminding me of that.)
> >
> > Thanks loads,
> >
> > Yosi
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: Yosi_at_comhill.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: Michael Netrusov
> INET: mn_at_g-fax.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: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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