Your syntex is wrong I guess. you can not use the reuse option when you specify the size for datafile.
Originally posted by MDSDBA
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;