My shop has the same problem as most of the posts I've read regarding TEMP tablespace filling up. So, I am investigating. I noticed that my TEMP tablespace is allocated as a DATAFILE, not a TEMPFILE. This confuses me....was this created incorrectly? Also, I believe my extents are not coded correctly for our environment, please advise. Thank you for your time.

SORT_AREA_SIZE 2927641
DB_BLOCK_SIZE 8192

CREATE TABLESPACE "TEMP" DATAFILE '/data/SRMDEVA/temp1.dbf' SIZE 104857600 REUS
E DEFAULT STORAGE(INITIAL 524288 NEXT 524288 MINEXTENTS 1 MAXEXTENTS 1000 PCTINCREASE 0) ONLINE TEMPORARY;