query help

Hello Doug

Try this Select statement:

select
s.segment_name,s.segment_type,s.tablespace_name,s.next_exten t
from dba_segments s
where not exists ( select 1 from dba_free_space f

                   where s.tablespace_name = 
f.tablespace_name
                   having max(f.bytes) > s.next_extent);

  Yours Sincerely

    Mario Bucsics

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!