From: pkelley@coat.com (Paul)
Newsgroups: comp.database.oracle,comp.databases.oracle
Subject: Re: "ORA-00935: group function is nested too deeply" in oracle8.1.7
Date: 8 Aug 2002 13:51:02 -0700
Organization: http://groups.google.com/
Lines: 33
Message-ID: <473377b4.0208081251.6019387d@posting.google.com>
References: <59b71f2d.0208080156.1c7ef5b@posting.google.com>
NNTP-Posting-Host: 204.194.82.199
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1028839862 20359 127.0.0.1 (8 Aug 2002 20:51:02 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2002 20:51:02 GMT


Try "order by Flow" instead of "order by sum(Flow)". 

mmrgood@sina.com (Mary.M) wrote in message news:<59b71f2d.0208080156.1c7ef5b@posting.google.com>...
> Hi, all gurus,
> 
> I encounter a very weird thing, who can help me?
> 
> I have a SQL statement:
> "select IPAddr,sum(Flow)/1048576 Flow,avg(FlowRate)/1024 FlowRate from
> (select SrcAddr as IPAddr,sum(Octets) Flow,sum(Octets)/(count(*) *
> 86400) FlowRate from TrafficComingDailyData where DestAddr =
> '192.168.0.130' and StartTime >= to_date('2002-8-1','yyyy-mm-dd
> hh24:mi:ss') and StartTime < to_date('2002-8-8 17:8','yyyy-mm-dd
> hh24:mi:ss') group by SrcAddr
> union all 
> select DestAddr as IPAddr,sum(Octets) Flow,sum(Octets)/(count(*) *
> 86400) FlowRate from TrafficGoingDailyData where SrcAddr =
> '192.168.0.130' and
> StartTime >= to_date('2002-8-1','yyyy-mm-dd hh24:mi:ss') and 
> StartTime < to_date('2002-8-8 17:8','yyyy-mm-dd hh24:mi:ss') group by
> DestAddr)
> group by IPAddr order by sum(Flow) desc"
> 
> When I run it under oracle8.1.5, there is no prblem.
> But when I run it under oracle8.1.7, error happends:
> " group by IPAddr order by sum(Flow) desc
>                           *
> ERROR at line 10:
> ORA-00935: group function is nested too deeply".
> 
> What is the reason?
> Thanks in advance!
> By Mary.M.