RE: delete statistics error?

Hi

If you have user-defined statistics try to run "analyze table user1.mywork delete system statistics". This only applies to 9i and 10g.

HTH
Chris

> On 07/08/06, dba1 mcc <mccdba1_at_yahoo.com> wrote:
>
> analyze table user1.mywork delete statistics;
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-20101: Do Not ANALYZE MYWORK
> ORA-06512: at line 1
>

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