Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: delete statistics error?
Hi,
ORA-20*** is a user defined error. Some has written "before analyze"
system
trigger for the table MYWORK.
Thanks and Regards,
Satheesh Babu.S
Bangalore.
> ----- Original Message -----
> From: "dba1 mcc" <mccdba1_at_yahoo.com>
> To: <oracle-l_at_freelists.org>
> Sent: Monday, August 07, 2006 2:30 PM
> Subject: delete statistics error?
>
>
> > I tried to delete one of my table's statistics and got
> > error. If I login as "system" and there is NO error.
> > Anyone know why?
> >
> > 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
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 08 2006 - 09:54:03 CDT