Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Blog Post

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

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

ERROR

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

SOLUTION

Step 1. Connect To SYS user from SqlPlus

Step 2. Take Backup of FND_STATTAB  Table.

Step 3. Run EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE(‘APPLSYS’,’FND_STATTAB’);

Related Posts
Write a comment