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@xxxxxxxxx> > To: <oracle-l@xxxxxxxxxxxxx> > 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 > > -- > > //www.freelists.org/webpage/oracle-l > > > > > -- //www.freelists.org/webpage/oracle-l