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: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sun, 13 Oct 2002 16:24:14 +0200
Message-ID: <qe0jqu0kda6ri08if0v663go94lb1alnj8@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 - 09:24:14 CDT

Original text of this message

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