Create or Assign New Temporary tablespace in Oracle Database

1.Create Temporary Tablespace TempNew

2.Make the default tablespace to TemNew

3.Drop temp tablespace TEMP

First Query To Check current temporary tablespace 

SELECT * FROM database_properties WHERE property_name like '%TABLESPACE'

1) Create another Temporary Tablespace TEMP2

 -CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE '/ebs/TOSC/db/data/temp2_new.dbf' SIZE 3g TABLESPACE GROUP TEMP;

2) Make Default Database temp tablespace  TEMP2

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP2;

3) drop tablespace temp1 INCLUDING CONTENTS AND DATAFILES;