Temp tablespace file grew to 32GB
I have Oracle 9i Standard server on Windows 2000 Server. I had Temp tablespace file grow to its limit of 32GB. Since the database had no other files in the tablespace I created another file for temporary solution.
The data in the database use about 8.6GB, and I am wondering what could cause such growth. If this is a query, is there a way to trace it? I am also looking for the best way to decrease the space of the database. My colleague proposes that I just drop the file and recreate it. Is that safe? Is there a way to just free up some space in the file and then shrink it?