Export and Import of Statistics

1) Create a table to hold the exported statistics

SQL>  EXEC DBMS_STATS.CREATE_STAT_TABLE('PA','TABLE_NAME');

2) Export the statistics

$ exp system tables=pa.TABLE_NAME file=TABLE_NAME.dmp log=TABLE_NAME.log

COPY THE DUMP FILE TO TARGET INSTANCE

And run the below

$ imp system tables=TABLE_NAME file=TABLE_NAME.dmp fromuser=pa

SQL> EXEC DBMS_STATS.IMPORT_TABLE_STATS(ownname => 'PA', tabname => 'PA_PROJ_ELEMENTS', stattab => 'TABLE_NAME');

PL/SQL procedure successfully completed.