10/24/2012

Oracle How to add tempfile

In order to  add a tempfile into the mounted  opened Oracle RDBMS:
Login to database command line as sysdba 

SQL> connect /as sysdba
Type 

SQL> ALTER TABLESPACE <TABLESPACE_NAME> ADD TEMPFILE
'PATH_TO_TABLESPACE_FILE' size 32000M reuse;

Example:

SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE
'/oracle/SID/sapdata2/temp_2/temp.data2' size 32000M reuse;

SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE
'/oracle/SID/sapdata3/temp_3/temp.data3' size 32000M reuse;

SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE
'/oracle/SID/sapdata4/temp_4/temp.data4' size 32000M reuse;


This was an easiest way how to add tempfile into Oracle TEMP tablespace.


No comments:

Post a Comment

Popular Posts