Reached limit on Temp Tablespace Extents

Hi,

     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 tablespaces 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.
Any suggestions would be appreciated
Guy Received on Thu Oct 06 1994 - 05:08:42 CET