Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms.stats problem

Gensis2001Sep 25 2012 — edited Sep 26 2012

I'm getting the following error running dbms_stats.gather_table_stats:
user@db:> exec dbms_stats.gather_table_stats( user, 'CHECK', 'CHECK2020' );
BEGIN dbms_stats.gather_table_stats( user, 'CHECK', 'CHECK2020' ); END;

*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_STATS", line 15027
ORA-06512: at "SYS.DBMS_STATS", line 15049
ORA-06512: at line 1

I'm running Oracle 10.2.0.5 (64bit) on RedHat Linux 5 (2.6.18-274.el5) (64bit). It seems this error only occurs with partitioned tables. I can analyze table check compute statistics and it completes but when I look at last_analyzed, the date doesn't change to the updated day. I searched for this error but saw that it only occurred in 10.2.0.3 and was fixed after that. Does anyone have any ideas?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 24 2012

Added on Sep 25 2012

#general-database-discussions

2 comments

515 views