If we are facing the issue ORA-20002, then we can perform the below work around.This basically occurs if any Database is upgraded.
Issue:
ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old
Solution:
1. Connect to sqlplus / as sysdba
2. Take a Backup of FND_STATTAB table
3. Run EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE(‘APPLSYS’,'FND_STATTAB’);
Issue:
ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old
Solution:
1. Connect to sqlplus / as sysdba
2. Take a Backup of FND_STATTAB table
3. Run EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE(‘APPLSYS’,'FND_STATTAB’);
Post a Comment
Post a Comment