Re: How ca I retrieve the space left in an extent ?

Laurent Bouyer wrote:
>
> Hello,
>
> I want to add a column to this request to show the place left in the
> last extent of a segment ;
>
> select substr(tbl.tablespace_name, 1, 10) , substr(tbl.segment_name, 1,
> 15), max_extents "MAX EXT.", next_extent, extents "EXT.", max(spc.bytes)
> "MAX. BYTES"
> from sys.dba_segments tbl, sys.dba_free_space spc
> where tbl.tablespace_name = spc.tablespace_name
> group by substr(tbl.tablespace_name, 1, 10) , substr(tbl.segment_name,
> 1, 15), max_extents, next_extent, extents
> order by 5 desc;
>
> How ca I do ??
>
> Laurent
> lbouyer_at_sin-et-stes.fr

Check out the DBMS_SPACE package...Also if you have analyzed you tables recents, you can get some useful information for tables via EMPTY_BLOCKS from dba_tables

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse