Below is error I got when we the dbms_stats, it only happened on the huge tables with more 10million rows. there are so many posted on metalink about this dbms_stats and oracle mentioned it will be fixed on 9.2.0.5.

any thoughts???


BEGIN dbms_stats.gather_database_stats(cascade=>TRUE); END;
*
ERROR at line 1:
ORA-00904: : 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 10134
ORA-06512: at "SYS.DBMS_STATS", line 10114
ORA-06512: at line 1