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/11411056/viewspace-733451/ ，如需转载，请注明出处，否则将追究法律责任。
