- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
How to deal with statistics during migration
I am carrying a migration on from Oracle 184.108.40.206 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:
-Fixed objects 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?