Temporary tablespace in Oracle Sunday, March 22, 2009

HI All,

Here is the procedure to change the temporary tablespace in oracle:

CREATE TEMPORARY TABLESPACE psaptemp1 TEMPFILE '/oracle/SRP/sapdata2/temp_1/temp1.data1' SIZE 3000M;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE psaptemp1;

DROP TABLESPACE psaptemp INCLUDING CONTENTS AND DATAFILES;

select tablespace_name from dba_temp_files;

make sure new tablespace has been added .


Regards,
Gagan