Recreating the temp tablespace

First, create a new temporary tablespace and set the new temp tablespace at the database level:

SQL> create temporary tablespace temp2 tempfile ‘+data’;

Tablespace created.

SQL>  alter database default temporary tablespace temp2;

Database altered.

 

Drop the original temp tablespace:

SQL> drop tablespace temp;

Tablespace dropped.
 

Create the new temp tablespace and set the new default temporary tablespace at the database level:

SQL> create temporary tablespace temp tempfile ‘+data’ size 1g;

Tablespace created.

SQL> alter database default temporary tablespace temp;

Database altered.