比如有一张表:signals_120628
想把这种表的数据快速的导入到分区表signals,方法如下:
ALTER TABLE SIGNALS EXCHANGE PARTITION P120628 WITH TABLE signals_120628;
花了 26秒。
Executed in 26.437 seconds
SQL> select count(*) from SIGNALS partition(P120628);
COUNT(*)
3803257
比如有一张表:signals_120628
想把这种表的数据快速的导入到分区表signals,方法如下:
ALTER TABLE SIGNALS EXCHANGE PARTITION P120628 WITH TABLE signals_120628;
花了 26秒。
Executed in 26.437 seconds
SQL> select count(*) from SIGNALS partition(P120628);
COUNT(*)
3803257
转载于:https://my.oschina.net/u/3635497/blog/3052719