Creating the Temporary TableSpace

Creating the Temporary TableSpace:

How to create the temporary tablespace :

-->Use the CREATE TEMPORARY TABLESPACE statement to create a locally managed temporary tablespace, which is an allocation of space
in the database that can contain schema objects for the duration of a session. If you subsequently
assign this temporary tablespace to a particular user, then Oracle will also use this tablespace for
sorting operations in transactions initiated by that user.

Creating the Temporary TableSpace:

sys>>CREATE TEMPORARY TABLESPACE temp1
                    TEMPFILE '/disk1/oradata/ORCL/temp01.dbf' SIZE 5M AUTOEXTEND ON;

Adding the tempfile to temporary tablespace:

sys>>alter tablespace temp1 add tempfile '/disk1/oradata/ORCL/temp01.dbf' size autoextend on;

Increasing the size of the tempfile :
  
sys>>alter database tempfile '/disk1/oradata/ORCL/temp01.dbf' resize 10m;

 Droping the temp file :

sys>>alter tablespace temp1 drop tempfile /disk1/oradata/ORCL/temp01.dbf';


sys>>select filename,tablespace_name from dba_temp_files;

for more information check the data dictionary views
 
sys>desc dba_temp_files;

To make the tablespace default temporary tablespace :

sys>>alter database default temporary tablespace temp1;