RE: Cleaning up before upgrades / migrations; avoiding upgrade pr

I did the upgrade from 7.3.4 to 8.1.5 about a year ago using export/import as you plan to do. I used version 7.3.4 export and import utilities and had no problems. I have been doing cleanup ever since, its a living ;)

Dean Jefferson
Database Administrator
State of Wisconsin
Office of Commissioner of Insurance
Dean.Jefferson_at_oci.state.wi.us

> -----Original Message-----
> From: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca]
> Sent: Friday, March 23, 2001 7:16 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jefferson, Dean
  INET: Dean.Jefferson_at_oci.state.wi.us

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