Moving Statistics from One Database to Other Database
I had recently upgraded the Database from 10.1.0.4 to 10.2.0.4, I had saved the statistics in table sys.dictstattab. I want to test the statistics on the Test Database.
There are four basic steps to copy the statistics from one database to another database using DBMS_STATS:
1) Create a table in your database to hold the statistics.
2) Move the statistics from the data dictionary to the table you created in step 1.
3) Use the Oracle export/import tools to move the data (statistics) from the holding table in your database to a second database.
4) Populate the data dictionary of the second database with the statistics from the holding table that were copied from the original database.