delete statistics error?

  • From: dba1 mcc <mccdba1@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 7 Aug 2006 11:30:42 -0700 (PDT)

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


Other related posts: