Re: Error when running dbms_stats

From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
To: Harvinder.Singh@xxxxxxxxxxxxx
Date: Wed, 31 Jan 2007 18:29:05 -0700

Did you recently upgrade to 9.2.0.8?
There was an almost identical post just recently.

At 04:04 PM 1/31/2007, oracle-l-bounce@xxxxxxxxxxxxx wrote:

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;


Regards

Wolfgang Breitling
Centrex Consulting Corporation

www.centrexcc.com


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

References:

Error when running dbms_stats
From: Harvinder . Singh

Re: Error when running dbms_stats

Other related posts: