Moving the PSAPTEMP Temporary Tablespace

Here is a procedure to move PSAPTEMP temporary tablespace. It's for windows, but you can translate for Unix.


In Windows

md \ORACLE\\SAPDATA1\PSAPTEMP

Create TEMPORARY TABLESPACE TEMP01
TempFile '\ORACLE\\SAPDATA1\PSAPTEMP\TEMP01_01.dbf' Size 1024M Reuse Uniform Size 1M Extent Management Local;

alter database default temporary tablespace TEMP01;
drop tablespace PSAPTEMP;

create temporary tablespace PSAPTEMP
TempFile '\ORACLE\\SAPDATA1\PSAPTEMP\TEMP_1.dbf' Size 4096M Reuse Uniform Size 1M Extent Management Local;
alter database default temporary tablespace PSAPTEMP;
drop tablespace TEMPO1;