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
1 comment:
Helpful post. Thanks a lot for sharing the procedure to create a temporary tablespace. I like visiting your blog very often as you always share new and interesting facts about Oracle. Thanks for putting you efforts.
sap upgrade assessment
Post a Comment