Re: delete statistics error?

From: Satheesh Babu.S <satheeshbabu.s_at_gmail.com>
Date: Tue, 8 Aug 2006 07:59:38 -0400
Message-ID: <00a101c6bae2$2409e000$65428eca@AryaanTechies>

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-l

Received on Tue Aug 08 2006 - 06:59:38 CDT