Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 31914 invoked from network); 8 Aug 2006 07:00:35 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 8 Aug 2006 07:00:35 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8A79D3BD5FF; Tue, 8 Aug 2006 08:00:18 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32287-07; Tue, 8 Aug 2006 08:00:18 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0F4C93BD694; Tue, 8 Aug 2006 08:00:18 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Aug 2006 07:59:28 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9B5093BD650 for ; Tue, 8 Aug 2006 07:59:28 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32035-01 for ; Tue, 8 Aug 2006 07:59:28 -0400 (EDT) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.188]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3FCDF3BD63D for ; Tue, 8 Aug 2006 07:59:28 -0400 (EDT) Received: by nf-out-0910.google.com with SMTP id c29so205936nfb for ; Tue, 08 Aug 2006 04:59:43 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:from:to:references:subject:date:mime-version:content-type:content-transfer-encoding:x-priority:x-msmail-priority:x-mailer:x-mimeole; b=lajQL+22Nz7cZCqub0Ys4DM5TClpeWukP+iYiGT0NRqXh0khc4sPl7TmFOblljZ6J62eZvkz42uBJbEVZXDDwb4T1wVxkGjVhsBj1M6t8Qt0sVQ74K9x18gP/DjU5kFA0oxd1bSquktHPjerTknQeZzbo5WuMOd8iDWwtBA1za4= Received: by 10.78.183.8 with SMTP id g8mr2730291huf; Tue, 08 Aug 2006 04:59:42 -0700 (PDT) Received: from AryaanTechies ( [202.142.66.217]) by mx.gmail.com with ESMTP id 39sm2279287hug.2006.08.08.04.59.40; Tue, 08 Aug 2006 04:59:41 -0700 (PDT) Message-ID: <00a101c6bae2$2409e000$65428eca@AryaanTechies> From: "Satheesh Babu.S" To: References: <20060807183042.78316.qmail@web60818.mail.yahoo.com> Subject: Re: delete statistics error? Date: Tue, 8 Aug 2006 07:59:38 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-archive-position: 37862 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: satheeshbabu.s@gmail.com Precedence: normal Reply-to: satheeshbabu.s@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net 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" To: 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