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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Error when running dbms_stats

RE: Error when running dbms_stats

From: William Wagman <wjwagman_at_ucdavis.edu>
Date: Wed, 31 Jan 2007 15:51:40 -0800
Message-ID: <FE043305B38A0F448F3924429D650C2A011AEA34@VEXBE2.ex.ad3.ucdavis.edu>


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_at_ucdavis.edu
(530) 754-6208
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
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

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jan 31 2007 - 17:51:40 CST

Original text of this message

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