[Oracle] Drop/Create temp tablespace

CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE  ‘/path/to/file.dbf′ SIZE 1000M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;

Kill All sessions !!

DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;