1 startup

2 create temporary tablespace temp1 tempfile '/data/prod/proddata/temp02.dbf' size 2048m reuse autoextend on next 640k maxsize unlimited;

3 alter database default temporary tablespace temp1;

4 drop tablespace temp including contents and datafiles;

5 create temporary tablespace temp tempfile '/data/prod/proddata/temp01.dbf' size 2048m reuse autoextend on next 640k maxsize unlimited;

6 alter database default temporary tablespace temp;

7 drop tablespace temp1 including contents and datafiles;

8 alter user roll temporary tablespace temp;