表统计信息导出导入脚本
---导出
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;
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29953799/viewspace-1466039/ ，如需转载，请注明出处，否则将追究法律责任。
