Forum Stats

  • 3,840,001 Users
  • 2,262,557 Discussions
  • 7,901,121 Comments

Discussions

How to deal with statistics during migration

Hello.

I am carrying a migration on from Oracle 11.2.0.4 to 19.3.

Source server is AIX 7.1. Destination is RHEL 7.

I am doing a schema export/import with datapump.


I am looking for the best way to deal with statistics:

-Systems statistics

-Dictionnary statistics

-Fixed objects statistics

-Databse statistics

Should I export/import them with datapump or dbms_stats or should I gather them on the new server?

Has anybody gone through this kind of migration?

Thanks.

Comments