Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: drop user user_name cascade - question
On Sun, 13 Oct 2002 16:24:14 +0200, Sybrand Bakker wrote:
>On Sun, 13 Oct 2002 16:12:54 +0200, "Tom Miskiewicz"
><miskiewicz2_at_no.spam.yahoo.com> wrote:
>
>>Your query gives me:
>>
>>SQL> select segment_name, count(*) from dba_extents
>> 2 group by owner having owner='ARADMIN';
>>select segment_name, count(*) from dba_extents
>> *
>>ERROR at line 1:
>>ORA-00979: not a GROUP BY expression
>
>should be corrected to
>select segment_name, count(*)
>from dba_extents
>where owner = 'ARADMIN'
>group by segment_name
Why not :
select segment_name, extents
from dba_segments
where owner = 'ARADMIN';
Received on Sun Oct 13 2002 - 14:48:00 CDT