ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old.

今天在收集9i的统计信息导入到11g是发现无法兼容的问题。

SQL> begin

  2    dbms_stats.import_table_stats(ownname => 'REINSUDATA' ,tabname =>  'FAC_ENDORSE' , stattab => 'FWYSTAT' ,statown =>  'DBMGR') ;

  3  end ;

  4  /

begin

*

ERROR at line 1:

ORA-20002: Version of statistics table DBMGR.FWYSTAT is too old.  Please try

upgrading it with dbms_stats.upgrade_stat_table

ORA-06512: at "SYS.DBMS_STATS", line 11013

ORA-06512: at "SYS.DBMS_STATS", line 12396

ORA-06512: at line 2

 

真的很奇怪，导出的统计信息居然无法导入，还提示要更新一下。

上metalink上查了一下，居然是11g的内部兼容问题，9i的执行计划在11g上识别不了，必须更新一下才能识别。

Cause
This is part of the 11g interoperatibility requirements. Note 452783.1, step 13: "Upgrade the database instance" includes the following:

"When upg