Copy stats from one database to another expdp, impdp 1 table

<schema>
<table1>
<table2>
<sysadmin_user>
<sysadmin_password>

 

exec dbms_stats.create_stat_table ( ownname => '<schema>' , stattab => 'temp_stat_<table1>' ) ;
exec dbms_stats.create_stat_table ( ownname => '<schema>' , stattab => 'temp_stat_<table2>' ) ;

 

exec dbms_stats.export_table_stats ( ownname => '<schema>' , stattab => 'temp_stat_<table1>', tabname => '<table1>', statid => 'stats03252011') ;
exec dbms_stats.export_table_stats ( ownname => '<schema>' , stattab => 'temp_stat_<table2>', tabname => '<table2>', statid => 'stats03252011') ;

expdp <sysadmin_user>/<sysadmin_password> tables=<schema>.temp_stat_<table1>,<schema>.temp_stat_<table2> directory=stjdump dumpfile=stats.dmp logfile=exp_stats.log

impdp <sysadmin_user>/<sysadmin_password> tables=<schema>.temp_stat_<table1>,<schema>.temp_stat_<table2> directory=stjdump dumpfile=stats.dmp logfile=imp_stats.log

exec dbms_stats.import_table_stats ( ownname => 'STJCONSOLIDATED' , stattab => 'temp_stat_<table1>', tabname => '<table1>' );
exec dbms_stats.import_table_stats ( ownname => 'STJCONSOLIDATED' , stattab => 'temp_stat_<table2>', tabname => '<table2>' );