Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: drop user user_name cascade - question

Re: drop user user_name cascade - question

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Mon, 14 Oct 2002 05:23:14 +1000
Message-ID: <ICjq9.52003$g9.151113@newsfeeds.bigpond.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US