1. Migrating Non-CDBs to New Hardware with the Same Operating System and for a New Release
  2. Post-Upgrade Tasks for Oracle Database
  3. Required Tasks to Complete After Upgrading Oracle Database
  4. Upgrading Statistics Tables Created by the DBMS_STATS Package After Upgrading Oracle Database

Upgrading Statistics Tables Created by the DBMS_STATS Package After Upgrading Oracle Database

If you created statistics tables using the DBMS_STATS.CREATE_STAT_TABLE procedure, then upgrade these tables by running DBMS_STATS.UPGRADE_STAT_TABLE.

In the following example, green is the owner of the statistics table and STAT_TABLE is the name of the statistics table. 

EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE('green', 'stat_table');

Perform this procedure for each statistics table.

See Also:

Oracle Database PL/SQL Packages and Types Reference for information about the DBMS_STATS package

Parent topic: Required Tasks to Complete After Upgrading Oracle Database