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: jwilton_at_speakeasy.net
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).
Received on Mon Jan 21 2002 - 13:30:58 CST
