Re: Reached limit on Temp Tablespace Extents

Your TEMP tablespace initial extent size should be bigger than your SORT_AREA_SIZE (in the INIT.ORA), since you only use temporary segments when you can't fit what you want to sort into memory. If your default storage parameter uses a PCTINCREASE of 0, and your next extent is the same size as your initial extent, you won't have to worry about fragmentation, and you can easily calculate the largest temporary segment that can be created and how many of these temporary segments will fit into your TEMP tablespace (can be important if you have lots of users).

-- 
Jennifer Corliss is on an InterGalactic cruise...       |The opinions expressed 
                                                        |above may not be those
   ...in her office                                     |of my employer.