Create a temporary tablespace

Hi

     I am giving the script to create a temporary tablespace. One temporary tablespace should be default temporary tablespace. If you want create a new temporary tablespace then you have to make default temporary  tablespace new one. and you can drop older one.


create temporary tablesapce temp1 tempfile '/a01m/oradata/ilproddata/temp1_01.dbf' size 5000m;

alter database  default temporary tablespace temp1;

Drop tablespace temp including contents and datafiles;