Re: Help with select statement
From: Stan Towianski <stantow_at_ibm.net>
Date: 1997/06/05
Message-ID: <339718a9.0_at_news1.ibm.net>#1/1
Date: 1997/06/05
Message-ID: <339718a9.0_at_news1.ibm.net>#1/1
A few people responded that I needed to move the count( extent_id ) > 20 to a trailing 'having' statement thru email only.
That did it.
Thanks.
where ( owner like 'MANU%' or owner like 'ACCOUNT%' ) and count( extent_id )
>20
group by owner, segment_name, segment_type
\/
select owner, segment_name, segment_type, count( extent_id )
from dba_extents
where ( owner like 'SYS%' or owner like 'ACCOUNT%' )
group by owner, segment_name, segment_type
having count( extent_id ) > 20
stantow_at_ibm.net Received on Thu Jun 05 1997 - 00:00:00 CEST