RE: Error when running dbms_stats
- From: "William Wagman" <wjwagman@xxxxxxxxxxx>
- To: <Harvinder.Singh@xxxxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 31 Jan 2007 15:51:40 -0800
Harvinder,
I encountered the same problem and it does not seem to be consistent.
The fix I was given was to
SQL> alter session set"_complex_view_merging"=false;
That solved the problem for me. I have no explanation as to why or what
is going on but give that a try.
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Sent: Wednesday, January 31, 2007 3:04 PM
To: oracle-l
Subject: Error when running dbms_stats
Hi,
I am running the following script and getting errors:
begin
dbms_stats.gather_schema_stats(ownname=> 'HS',estimate_percent=>
100,degree=> dbms_stats.auto_degree,granularity=> 'AUTO',method_opt=>
'FOR ALL COLUMNS SIZE AUTO',options=> 'GATHER',cascade=> TRUE);
end;
ERROR at line 1:
ORA-00979: not a GROUP BY expression
ORA-06512: at "SYS.DBMS_STATS", line 13210
ORA-06512: at "SYS.DBMS_STATS", line 13556
ORA-06512: at "SYS.DBMS_STATS", line 13634
ORA-06512: at "SYS.DBMS_STATS", line 13593
ORA-06512: at line 2
This was working before, what can be the possible issue?
Thanks
--Harvinder
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
