I have Oracle 220.127.116.11 running on Compaq Tru64 UNIX V5.1
I have run into a problem with the temp tablespace.
I first noticed it when some of my webpages that are served off the database stopped working giving the following error message:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
I opened up the folder where the file lives and it appeared as though the drive was full. The TEMP01.dbf file was around 11GB!!. I made some room by removing some other files but it still didnt work. I then went into enterprise manager and the temp tablespace is showing up as 0 MB.
This is an online system so I cant test a solution... I need a solution that works and please dont hesitate to ask any questions.
P.S. I suspect the TEMP file blew out because of a new procedure that was being tested. I just need to get it back up and running.