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.