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.
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;
Click Here to Expand Forum to Full Width