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;

  • April 24, 2012 | 25 views
  • Comments