Re: Reached limit on Temp Tablespace Extents
From: BARRY ROOMBERG <barry.roomberg_at_compudata.com>
Date: Fri, 07 Oct 94 09:24:00 -0400
Message-ID: <89B5234.0389001547.uuout_at_compudata.com>
Date: Fri, 07 Oct 94 09:24:00 -0400
Message-ID: <89B5234.0389001547.uuout_at_compudata.com>
-> The maximum number of segment extents which oracle supports is
-> platform specific. For example on many unix variants the max extents
-> per segment is 121. You should allocate more temp space and temp
-> change your temp tablepsace assignment to build the index. Make the
-> default storage params for initial extent size large so that you do
-> not run out of extents.
Nope. It's a function of block size, and you can change block size. Changing the default initial extent will help this guy, at the expense of wasting space for any small tables created here (which should not happen since you shouldn't mix temp and other tables) Received on Fri Oct 07 1994 - 14:24:00 CET