Sap Pandit !!

Complete SAP-BASIS Solution

Temporary tablespace in Oracle


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

March 22, 2009 Posted by | Temporary tablespace in Oracle | Leave a comment

   

Follow

Get every new post delivered to your Inbox.

Join 28 other followers