Does the "autoextend" becomes off (if it was on) after resizing datafile
We are resizing datafile to shrink tablespace in Oracle 10 gR2(10.2.0.4.0). We are using the following script to do it:
select 'alter database datafile '''||file_name||''' resize ' ||
ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) || 'm;' cmd
from dba_data_files a,
( select file_id, max(block_id+blocks-1) hwm
from dba_extents
group by file_id ) b
where a.file_id = b.file_id(+)
and ceil( blocks*&&blksize/1024/1024) -
ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) > 0;
Does the "autoextend" becomes "off" (if it was "on") after running the generated script from the above?