我現在要將四個普通表的數據放在某个分區表中,但是移動的時候分區必須是空的啊;請問下面有什麼好辦法解決啊?高手請進!謝謝!
alter table m_cartonlot_t081 switch to m_cartonlot_t partition 2
alter table m_cartonlot_t082 switch to m_cartonlot_t partition 2
alter table m_cartonlot_t083 switch to m_cartonlot_t partition 2
alter table m_cartonlot_t084 switch to m_cartonlot_t partition 2
alter table m_cartonlot_t081 switch to m_cartonlot_t partition 2
alter table m_cartonlot_t082 switch to m_cartonlot_t partition 2
alter table m_cartonlot_t083 switch to m_cartonlot_t partition 2
alter table m_cartonlot_t084 switch to m_cartonlot_t partition 2
http://www.rugesy.cn/it/u20071119_10_47984fe7-6d25-40c4-ac0d-2b45795cb3c0.html