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