If you wish to save your statistics of schema or table, which you can use later during any query issue Or if you wish copy the statistics from production database to development , then this method will be helpful.

Here i will take export of statistics of a table RAJ.TEST from PROD and import into TEST



create a table to store the stats:

Now export the statistics of the table RAJ.TEST to stats table ( STAT_TEST)


Now take expdp of this stats table(STAT_TEST)


Move the dump file from PROD to TEST machine and import the same



Now import the statistics in database:


We can observe after import_table_stats, last_analyzed date has been updated.

We can do export/import statistics at schema level and database level:

For database :

For schema: