RE: Error when running dbms

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Wed, 31 Jan 2007 18:08:39 -0500
Message-ID: <D6424CD4C8A3C044BBC49877ED51C51804E0277C@ex2003.metratech.com>

This is oracle 10.2.0.2 on RHAT4

-----Original Message-----

From: Harvinder Singh
Sent: Wednesday, January 31, 2007 6: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 Received on Wed Jan 31 2007 - 17:08:39 CST

RE: Error when running dbms_stats