copying statistics between databases

SQL> execute dbms_stats.create_stat_table('ocp007','stat_table','users');
PL/SQL 过程已成功完成。
SQL> execute dbms_stats.export_table_stats('ocp007','EMPLOYEES',null,'stat_table','mytest',true,null);
PL/SQL 过程已成功完成。
SQL> select table_name,num_rows,blocks,empty_blocks,avg_space,avg_row_len,sample_size
  2  from user_tables
  3  where table_name='EMPLOYEES';
TABLE_NAME                                                     NUM_ROWS     BLOCKS EMPTY_BLOCKS  AVG_SPACE AVG_ROW_LEN SAMPLE_SIZE
------------------------------------------------------------ ---------- ---------- ------------ ----
EMPLOYEES                                                           107          5            3       6249          82         107
SQL> analyze table employees delete statistics;
表已分析。
SQL> select table_name,num_rows,blocks,empty_blocks,avg_space,avg_row_len,sample_size
  2  from user_tables
  3  where table_name='EMPLOYEES';
TABLE_NAME                                                     NUM_ROWS     BLOCKS EMPTY_BLOCKS  AVG_SPACE AVG_ROW_LEN SAMPLE_SIZE
------------------------------------------------------------ ---------- ---------- ------------ ----
EMPLOYEES
SQL> execute dbms_stats.import_table_stats('ocp007','EMPLOYEES',null,'stat_table','mytest',true,null,false);
PL/SQL 过程已成功完成。
SQL> select table_name,num_rows,blocks,empty_blocks,avg_space,avg_row_len,sample_size
  2  from user_tables
  3  where table_name='EMPLOYEES';
TABLE_NAME                                                     NUM_ROWS     BLOCKS EMPTY_BLOCKS  AVG_SPACE AVG_ROW_LEN SAMPLE_SIZE
------------------------------------------------------------ ---------- ---------- ------------ ----
EMPLOYEES                                                           107          5            0          0          82         107

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/95429/viewspace-269151/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/95429/viewspace-269151/