Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 813 invoked from network); 8 Aug 2006 09:54:55 -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 09:54:55 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4833D3BD906; Tue, 8 Aug 2006 10:54:39 -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 00949-09; Tue, 8 Aug 2006 10:54:39 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C89023BD917; Tue, 8 Aug 2006 10:54:38 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Aug 2006 10:53:50 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 82C753BD8E9 for ; Tue, 8 Aug 2006 10:53:50 -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 00691-01 for ; Tue, 8 Aug 2006 10:53:50 -0400 (EDT) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.191]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 273AA3BD8A4 for ; Tue, 8 Aug 2006 10:53:50 -0400 (EDT) Received: by nf-out-0910.google.com with SMTP id c29so254616nfb for ; Tue, 08 Aug 2006 07:54:05 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:from:to:cc:subject:date:mime-version:content-type:content-transfer-encoding:x-priority:x-msmail-priority:x-mailer:x-mimeole; b=guDtktnOe/eOpYB3ugUMGZTEe4qFsqGo4KZrcG7FMslXOg2OYCGkquQXpw4YFpTbQOejC2ube/6XaJVg+jhwxY+UNFulZEFqdvkYhiDADb9tpUyysh6FG+wf2/nnNnXsva5QC6YKFps5ctVF1/j6P78Tnv1NWqOcW34HcOng4h4= Received: by 10.78.127.6 with SMTP id z6mr2811350huc; Tue, 08 Aug 2006 07:54:05 -0700 (PDT) Received: from AryaanTechies ( [202.142.66.217]) by mx.gmail.com with ESMTP id 2sm1990909huc.2006.08.08.07.54.03; Tue, 08 Aug 2006 07:54:04 -0700 (PDT) Message-ID: <001701c6bafa$8028b6a0$65428eca@AryaanTechies> From: "Satheesh Babu.S" To: Cc: Subject: Re: delete statistics error? Date: Tue, 8 Aug 2006 10:54:03 -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: 37874 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