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!

ORA-01422: While executing dbms_stats for tables.

lm422407shMar 17 2008 — edited Mar 17 2008

hi,

i am getting error while excuting dbms_status.

SQL> exec dbms_stats.gather_table_stats(ownname=>user,tabname=>'PS_FTP_CALC_IN_F00',estimate_percent=>25,cascade=>true);
BEGIN dbms_stats.gather_table_stats(ownname=>user,tabname=>'PS_FTP_CALC_IN_F00',estimate_percent=>25,cascade=>true); END;

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

Could someone please help me what could be the issue. the table is partitioned and it is not working only for few tables.

Thanks
Suresh Kumar

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2008

Added on Mar 17 2008

#general-database-discussions

2 comments

943 views