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 <[EMAIL PROTECTED]> 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. >[EMAIL PROTECTED] > > >-----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" <[EMAIL PROTECTED]> >Sent by: [EMAIL PROTECTED] > 03/31/2003 10:34 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
