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