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: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
Hth
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Sun Oct 13 2002 - 09:24:14 CDT