Can you elaborate on exactly what happened? 8.1.5 to 8.1.6 is just a catalog script and a binary change. What error did you encounter, and at which step in the upgrade? Extents should not matter in an upgrade.
-- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 21 Jan 2002, Dave Morgan wrote: > Actually, in extreme cases ( >87000 in my case, and I had 12 > tables > like that) it can cause problems with upgrading. Not sure what, but we > had to do CTAS into new tables with much larger extents to do the > upgrade from 8.1.5 to 8.1.6 here. Had Oracle support and consultants > baffled also > > I still like to keep the number of extents below 500, but I'm paranoid > :) > > Rachel wrote: > Snip .... > > There really is NO reason to worry about large numbers of extents these > > days. I mean, I wouldn't want to really test the "unlimited" ability > > but other than that, there is no problem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] 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: [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).