How to add a tempfile in Oracle

Unknown 8:51 AM No comments
To add a tempfile into the mounted  opened Oracle db:

SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE
'/oracle/SID/sapdata1/temp_1/temp.data1' size 32000M reuse;

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;

No comments :

Post a Comment

Subscribe to: Post Comments ( Atom )

Histats

Total Pageviews