Changing the default temporary tablespace of the database or reclaiming the space occupied by the current temporary tablespace

 Changing the default temporary tablespace for the database or reclaiming the space occupied by the current temporary tablespace

  The following procedure to be followed 

  a. create another temporary tablespace in another  drive ( windows ) or filesystem.(linux)

    CREATE TEMPORARY TABLESPACE  TEMP1 TEMPFILE '<PATH>/temp1_01.dbf' size 10g;

  b. Make it default for the database.

    ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP1;

  c. Drop the current temporary tablespace

    ALTER DATABASE TEMPFILE '<path>/temp1.dbf' DROP INCLUDING DATAFILES;