Reached limit on Temp Tablespace Extents

-> My TEMP table space cannot extend any futher when I am trying to
-> build an
-> index. The first time it was at 99 extents, so I raised it to 500(I
-> think the actual limit is 256). Now it stops at 122. I don't
-> understand this. If nothing is permanently stored in the temporary
-> tablespace, why doesn't it use all the space. The temporary
-> tablespace is 5M and my data and index tablespace s
-> are 10M each, so I feel I should have plenty of space. Can I
-> defragment the temporary tablespace somehow to get rid of the
-> extents(I couldn't find this in any book. Oracle error book says to
-> add another datafile, Great). Can I just drop the TEMP tablespace
-> and recreate it? Also, I am using Oracle Version 6, VMS, and no one
-> else is running an Oracle transaction while I'm trying to build this
-> index.

The actual number of extents allowed is based on the block size. What you need to do is increase the DEFAULT allocation for your temp table space. This'll A) make it work, B) Work a LOT faster, C) waste space if you use this tablespace for small tables. Received on Thu Oct 06 1994 - 15:30:00 CET