How to create a temporary tablespace in Oracle :


CREATE TEMPORARY TABLESPACE temp1 TEMPFILE 'D:\app\oracle\oradata\DATA\temp022.dbf' SIZE 1g REUSE AUTOEXTEND ON NEXT 400M MAXSIZE unlimited;