How ca I retrieve the space left in an extent ?

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 Received on Tue Jul 25 2000 - 00:00:00 CDT