Hi All,
In a DSS system (Oracle8i on NT) I have a big table (about 3GB) and a 4GB temporary tablespace (that is made up of 2 datafiles of 2 GB each)

I got a "ORA-1652: unable to extend temp segment by 207381 in tablespace TEMP1" error

I noticed that the temp tablespace is set with the following storage --

Initial - 40KB (I think it's too low because it's a DSS system)
Next - 40KB
pct_increase - 50%
max_extents - 505 (default value)

I think what is happening is that because of the non-zero pct_increase (causing different-size extents) it does not use all of the first datafile and moves to the second datafile wasting a lot of space; Same thing happens in the second datafile.

I am leaning towards using pct_increase as Zero and initial as 1MB (or more) and using unlimited max_extents

Does anybody have any opinion about using zero pct_increase ?

Thanks,

- Rajeev