Re: LMT not listed in DBA_FREE_SPACE

"NoResult" <dj_noresult_at_hotmail.com> wrote in message news:Xns9326CD42EE529djnoresult_at_194.109.133.20...
> Please note that this does not include auto extend. If a datafile is set
> to auto extend you should look in dba_data_files for the maximum size of
> the data file.

which is one reason not to use autoextend?

> Also exents should fit entirely in free blocks. In locally managed
> tablespaces the next extent of a segment (table, index, etc.) can grow up
> to 64 M.

which, more to the point is a perfect reason to use locally managed tablespaces, with the uniform extent size clause. then you know that if space is free a object can extend.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************