RE: problem with dbms_stats 9204 on hp-ux 11i

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

Sorry about the excessive spacing....that wasn't how it looked when I sent it out.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chris Stephens Sent: Monday, July 19, 2004 10:50 AM
To: oracle-l_at_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

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
-----------------------------------------------------------------
----------------------------------------------------------------
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:48:59 CDT