From oracle-l-bounce@freelists.org Mon Jul 19 10:48:59 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6JFmic10217 for ; Mon, 19 Jul 2004 10:48:54 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6JFmY610137 for ; Mon, 19 Jul 2004 10:48:44 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C8EDB72D10A; Mon, 19 Jul 2004 10:27:54 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27349-42; Mon, 19 Jul 2004 10:27:54 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 11BBA72D0AC; Mon, 19 Jul 2004 10:27:54 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 19 Jul 2004 10:26:20 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C1E8272CC03 for ; Mon, 19 Jul 2004 10:26:18 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26417-63 for ; Mon, 19 Jul 2004 10:26:18 -0500 (EST) Received: from mail1.affina.com (mail1.affina.com [12.20.72.19]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2503E72CF0C for ; Mon, 19 Jul 2004 10:26:18 -0500 (EST) Received: from apollo.affina.net (Not Verified[172.16.158.25]) by mail1.affina.com with MAIL Service, Version: 6.0 id ; Mon, 19 Jul 2004 10:52:00 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: RE: problem with dbms_stats 9204 on hp-ux 11i Date: Mon, 19 Jul 2004 10:52:00 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: problem with dbms_stats 9204 on hp-ux 11i Thread-Index: AcRtqA3/ela8k1NVTs6ODmUD9Gz26QAADneQ From: "Chris Stephens" To: X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 5406 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ChrisStephens@Affina.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Sorry about the excessive spacing....that wasn't how it looked when I sent it out. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Chris Stephens Sent: Monday, July 19, 2004 10:50 AM To: oracle-l@freelists.org Subject: problem with dbms_stats 9204 on hp-ux 11i I'm analyzing a schema... =20 exec dbms_stats.gather_schema_stats(ownname=3D>'XXX',estimate_percent=3D>20,ca= sca de=3D>true); =20 and receiving the following error... =20 * ERROR at line 1: ORA-00904: "TIMESTAMP": invalid identifier ORA-06512: at "SYS.DBMS_STATS", line 9375 ORA-06512: at "SYS.DBMS_STATS", line 9857 ORA-06512: at "SYS.DBMS_STATS", line 10041 ORA-06512: at "SYS.DBMS_STATS", line 10095 ORA-06512: at "SYS.DBMS_STATS", line 10072 ORA-06512: at line 1 =20 /*what a horrible name for a column....unfortunately, it's a canned app*/ =20 ...I've tried analyzing several of the individual tables with a column name of 'timestamp' without problems. =20 There is one table that errors on statistics collection.... =20 BEGIN dbms_stats.gather_table_stats(ownname=3D>'XXX',tabname=3D>'TTTTTTTTTTTT',= est imate_percent=3D>20); =20 * ERROR at line 1: ORA-20000: Unable to set values for column SYS_NC00015$: does not exist or insufficient privileges ORA-06512: at "SYS.DBMS_STATS", line 9375 ORA-06512: at "SYS.DBMS_STATS", line 9389 ORA-06512: at line 1 =20 On the latter error I've tried as sysdba and as the owner of the table. I don't know where to go from there. On the former error, how do I trap the actual table/index that is throwing the error? =20 Any suggestions? =20 ....great start to the week! =20 Thanks, Chris =20 =20 =20 =20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------