Oracle Database Experts

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

create temporary tablespace temp2 tempfile '+data';
Tablespace created.
alter database default temporary tablespace temp2;
Database altered.

Drop the original temp tablespace:

drop tablespace temp;
Tablespace dropped.

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

create temporary tablespace temp tempfile '+data' size 1g;<br />
<br />
Tablespace created.</p>
alter database default temporary tablespace temp;<br />
<br />
Database altered.

Posted by Charles Kim, Oracle ACE