select
f.file#,
round(f.bytes/1024/1024,2)||' Mb' megabytes,
decode(trunc(e.maxextend*blocksize/1000/10),
0,round(e.maxextend*blocksize,2)||' Mb',
null,null,
'Unlimited') maxextend,
decode(e.inc,null,null,round(e.inc*blocksize,2)||' Mb') inc,
ceil(nvl(r.min_resize,0)*blocksize)||' Mb' min_resize,
f.name
from
sys.filext$ e, v$datafile f,
( select
e.file_id file#,
max(e.block_id + e.blocks) as min_resize
from dba_extents e
group by e.file_id
) r,
(select to_number(value)/1024/1024 blocksize
from v$parameter where name='db_block_size')
where e.file#(+) = f.file#
and r.file#(+) = f.file#
order
by 1
ALTER DATABASE DATAFILE 'C:\ORATBS\USERS.DBF' RESIZE 10M;