Tag Archives: x$ktfbue

收集统计信息报错ORA-1422

10.2.0.4环境执行DBMS_STATS包时出现ORA-1422错误。 详细错误信息为: SQL> EXECUTE dbms_stats.gather_table_stats(ownname=> USER, tabname=> ‘X$KTFBUE’) BEGIN dbms_stats.gather_table_stats(ownname=> USER, tabname=> ‘X$KTFBUE’); END; ORA-01422: 实际返回的行数超出请求的行数 ORA-06512: 在 "SYS.DBMS_STATS", line 13437 ORA-06512: 在 "SYS.DBMS_STATS", line 13457 ORA-06512: 在 line 2SQL> execute dbms_stats.gather_table_stats(ownname=> USER, tabname=> ‘X$KTFBUE’) begin dbms_stats.gather_table_stats(ownname=> USER, tabname=> ‘X$KTFBUE’); … Continue reading

Posted in BUG | Tagged , , | Leave a comment