Re-creating New TEMP tablespace

Here are the steps: First create temp tablespace --Create Temporary Tablespace Temp2 CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE   '/oradata/testdb/temp02.dbf' SIZE 500M; Make the newly create tablespace as default one --Move Default Database temp tablespace ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2; Now drop the old tablespace --Drop temp tablespace DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;