- 21 Dec, 2023
- 0 Comments
- 1 Min Read
ORA-20002: Version Of Statistics Table SCOTT.STATS Is Too Old
Solution :
SQL> EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE('ABC','STAT_TEST');
PL/SQL procedure successfully completed.
exec dbms_stats.import_table_stats(ownname=>'ABC', tabname=>'TEST', stattab=>'STAT_TEST', cascade=>true); PL/SQL procedure successfully completed.