Oracle-L: RE: Upgrade from 8.1.7.4 to 9.2.0.1.0

From: <mail2gkatteri_at_netscape.net>
Date: Mon, 31 Mar 2003 11:48:48 -0800
Message-ID: <F001.00576938.20030331114848@fatcity.com>

Oracle 7 to Oracle 8 involves changes to the rowid itself. Hence the tablespaces are part of migration. For higher releases , the changes take place to the system , rbs tablespaces (if i recall correctly) and the user tablespaces are not touched by migration.

HTH GovindanK

DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:

>Jared - I agree with you. My understanding is that an Oracle upgrade just
>changes the data dictionary. An Oracle migration (like Oracle 7 to Oracle 8)
>involves changes to the tablespaces.
>
>Dennis Williams
>DBA, 40%OCP, 100% DBA
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com
>
>
>-----Original Message-----
>Sent: Monday, March 31, 2003 1:04 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Thomas,
>
>I think you will find this in either in the upgrade manual or MetaLink.
>
>IIRC it depends on the number of DD objects, but I can't recall where
>it was that I read that.
>
>Jared
>
>
>
>
>
>"Thomas Day" <tday6_at_csc.com>
>Sent by: root_at_fatcity.com
> 03/31/2003 10:34 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:
> Subject: Upgrade from 8.1.7.4 to 9.2.0.1.0
>
>
>
>Is this just a data dictionary upgrade?
>
>The real question is, does the down time for this upgrade depend on the
>number of objects in the data dictionary or on the overall used tablespace
>in the database?
>
>

Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380

Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promos=380455

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: mail2gkatteri_at_netscape.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Mon Mar 31 2003 - 13:48:48 CST