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: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Wed, 31 Jan 2007 18:29:05 -0700
Message-Id: <200702010129.l111T6lj029337@mail52.megamailservers.com>


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_at_freelists.org 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
Received on Wed Jan 31 2007 - 19:29:05 CST

Original text of this message

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