CREATE TEMPORARY TABLESPACE "MY_TEMP" TEMPFILE
'E:\oracle\ORADATA\TEST\my_tmp.dbf'
SIZE 150M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;


http://download-west.oracle.com/docs...5e.htm#2063487