表統計資訊匯出匯入指令碼

begin 
dbms_stats.create_stat_table('dbmgr','CBO_STATS_NET2');
dbms_stats.export_table_stats(ownname => 'NETS2DATA',
tabname => 'T_PC_ORDER',
stattab => 'CBO_STATS_NET2',
statown => 'DBMGR',
cascade => true,
statid  => 'T_PC_ORDER_STAT');
dbms_stats.export_table_stats(ownname => 'NETS2DATA',
tabname => 'T_PUB_CALL_RESULT',
stattab => 'CBO_STATS_NET2',
statown => 'DBMGR',
cascade => true,
statid  => 'T_PUB_CALL_RESULT_STAT');
dbms_stats.export_table_stats(ownname => 'NETS2DATA',
tabname => 'T_PUB_SALE_HISTORY',
stattab => 'CBO_STATS_NET2',
statown => 'DBMGR',
cascade => true,
statid  => 'T_PUB_SALE_HISTORY_STAT');
end;
/

begin 
dbms_stats.import_table_stats(ownname => 'NETS2DATA',
tabname => 'T_PC_ORDER',
stattab => 'CBO_STATS_NET2',
statown => 'DBMGR',
cascade => true,
statid  => 'T_PC_ORDER_STAT');
dbms_stats.import_table_stats(ownname => 'NETS2DATA',
tabname => 'T_PUB_CALL_RESULT',
stattab => 'CBO_STATS_NET2',
statown => 'DBMGR',
cascade => true,
statid  => 'T_PUB_CALL_RESULT_STAT');
dbms_stats.import_table_stats(ownname => 'NETS2DATA',
tabname => 'T_PUB_SALE_HISTORY',
stattab => 'CBO_STATS_NET2',
statown => 'DBMGR',
cascade => true,
statid  => 'T_PUB_SALE_HISTORY_STAT');
end;
/