Thursday, February 16, 2012

Turn off autoextend

Sometimes we need to turn off autoextend and resize the file to 10G. It can be done in very simple steps. Let take we have datafile like this c:\oracle\oradata\example01.dbf

alter database datafile 'c:\oracle\oradata\example01.dbf' resize 10G;
alter database datafile 'c:\oracle\oradata\example01.dbf' autoextend off;

That is all :)

No comments:

Post a Comment