To Identify all segments for a tablespace

select * from dba_segments where tablespace_name =’ENIX’ and next_extent > (select
max(BYTES) from dba_free_space where tablespace_name =’ENIX’) order by next_extent;