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

From: Chris Stephens <ChrisStephens_at_Affina.com>
Date: Tue, 20 Jul 2004 16:05:44 -0500
Message-ID: <E07BCCA62696AB40BE1267A7419A281A2B521F@apollo.affina.net>

Looks like I was lucky enough to simultaneously hit 2 bugs at once:

---> <Bug:3078144>Abstract: ORA-904 INVALID IDENTIFIER WHEN ANALYZING OBJECTS USING DBMS_STATS
@@@ARU: 9.2.0.4 ARU 5440791 available on HPUX-64 or 9205

and

---> <Bug:2879839> Abstract: ORA-20000 WITH DBMS_STATS AND = CASCADE=3DTRUE WORKAROUND:

---

1. USE CASCADE=3DFALSE

have a nice day!
chris

-----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

=20

=20

=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 Tue Jul 20 2004 - 16:02:29 CDT