From: mmrgood@sina.com (Mary.M)
Newsgroups: comp.database.oracle,comp.databases.oracle
Subject: "ORA-00935: group function is nested too deeply" in oracle8.1.7
Date: 8 Aug 2002 02:56:10 -0700
Organization: http://groups.google.com/
Lines: 30
Message-ID: <59b71f2d.0208080156.1c7ef5b@posting.google.com>
NNTP-Posting-Host: 218.2.150.98
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1028800570 11617 127.0.0.1 (8 Aug 2002 09:56:10 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2002 09:56:10 GMT


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.