title: Copy optimizer statistics - Oracle 10g
body: <p>I am trying to copy statistics from one schema to another. I use the following commands but on the destination schema num_rows on the all_tables view remains unchanged. Is there any view that I can check on the destination schema that verify that statistics movement?</p>
  
  <pre><code>EXEC DBMS_STATS.create_stat_table('DBASCHEMA','STATS_TABLE');
  EXEC DBMS_STATS.export_schema_stats('APPSCHEMA','STATS_TABLE',NULL,'DBASCHEMA');
  EXEC DBMS_STATS.import_schema_stats('APPSCHEMA','STATS_TABLE',NULL,'DBASCHEMA');
  EXEC DBMS_STATS.drop_stat_table('DBASCHEMA','STATS_TABLE');
  </code></pre>
  
  <p>Thank you.</p>