Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> delete statistics error?

delete statistics error?

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Mon, 7 Aug 2006 11:30:42 -0700 (PDT)
Message-ID: <20060807183042.78316.qmail@web60818.mail.yahoo.com>


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
Received on Mon Aug 07 2006 - 13:30:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US