Wednesday 24 April 2013

To add temp /data file 
 in oracle

To add  temp/ data file
 in oracle

ALTER TABLESPACE TEMP ADD TEMPFILE '/home/oracle/oracle/product/10.2.0/db_1/oradata/test/temp02.dbf' size 1g;

in linux platform

ALTER TABLESPACE TEMP ADD TEMPFILE 
'C:\Oracle\oradata\TEMP3\Temp02.dbf' size 50M reuse autoextend on next 1M maxsize 500M; in windows platform


In 11g we can shrink the temp tablespace.


To add the datafile:

alter tablespace la add datafile '
/home/oracle/oracle/product/10.2.0/db_1/oradata/test/la4.dbf' size
512m;

No comments:

Post a Comment