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