Moving Statistics from One Database to Other Database

I had recently upgraded the Database from to, 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.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *