Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: drop user user_name cascade - question
Oooops.
Sorry. It should of course have read exactly as you say.
Regards
HJR
"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
news:qe0jqu0kda6ri08if0v663go94lb1alnj8_at_4ax.com...
> 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 - 14:23:14 CDT