problem with dbms_stats 9204 on hp-ux 11i

From: Chris Stephens <ChrisStephens_at_Affina.com>
Date: Mon, 19 Jul 2004 10:50:03 -0500
Message-ID: <E07BCCA62696AB40BE1267A7419A281A2B5216@apollo.affina.net>

I'm analyzing a schema...  

exec
dbms_stats.gather_schema_stats(ownname=>'XXX',estimate_percent=>20,casca de=>true);  

and receiving the following error...  

*

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  

/*what a horrible name for a column....unfortunately, it's a canned app*/  

...I've tried analyzing several of the individual tables with a column name of 'timestamp' without problems.  

There is one table that errors on statistics collection....  

BEGIN
dbms_stats.gather_table_stats(ownname=>'XXX',tabname=>'TTTTTTTTTTTT',est imate_percent=>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  

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?  

Any suggestions?  

....great start to the week!  

Thanks,

Chris        

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_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
-----------------------------------------------------------------

Received on Mon Jul 19 2004 - 10:47:10 CDT