My Oracle Support Banner

Have To Drop APPLSYS.FND_STATTAB After Every Gather Schema Stats, How to fix Permanently (Doc ID 2023458.1)

Last updated on DECEMBER 28, 2020

Applies to:

Oracle Project Planning and Control - Version 12.2 and later
Information in this document applies to any platform.

Goal

PRC: Refresh Project and Resource Base Summaries errors after "Gather schema statistics" is run weekly.
ERROR:
     ORA-20002: Version Of Statistics Table APPLSYS.FND_STATTAB is too old.

After error the following is done
  1.TAKE backup of APPLSYS.FND_STATTAB
  2.drop table APPLSYS.FND_STATTAB
  3.exec dbms_stats.create_stat_table('APPLSYS','FND_STATTAB');

 Also, tried to upgrade the table
       "exec DBMS_STATS.UPGRADE_STAT_TABLE('APPLSYS','FND_STATTAB')"

 

But this happens every week, how can we fix this?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.