Задание 5. Перемещение секций
Переместим все секции с данными до 2015 и 2019 годов и все их индексы в области хранения OrderData2 и OrderIndex2.
- Перемещение секции Order_2015 и связанных с ней индексов в области OrderData2 и OrderIndex2:
proutil sportsco -C tablemove order orderdata2 orderindex2 partition order_2015
proenv>proutil sportsco -C tablemove order orderdata2 orderindex2 partition order_2015 OpenEdge Release 12.0 as of Fri Feb 22 19:02:39 EST 2019 Attempting to obtain an exclusive lock on order.order_2015:13 [13]... (8595) If you would like to cancel this operation, press CTRL-C. (8581) ...lock on order.order_2015:13 [13] has been obtained, tablemove in process. (8597) Table order.order_2015:13 [13] has been moved to area orderdata2 [410]. (8613) All indexes associated with table order.order_2015:13 [13] have been moved to area orderindex2 [411]. (8614) proenv>
- Перемещение секции Order_2019 и связанных с ней индексов в области OrderData2 и OrderIndex2:
proutil sportsco -C tablemove order orderdata2 orderindex2 partition order_2019
proenv>proutil sportsco -C tablemove order orderdata2 orderindex2 partition order_2019 OpenEdge Release 12.0 as of Fri Feb 22 19:02:39 EST 2019 Attempting to obtain an exclusive lock on order.order_2019:14 [13]... (8595) If you would like to cancel this operation, press CTRL-C. (8581) ...lock on order.order_2019:14 [13] has been obtained, tablemove in process. (8597) Table order.order_2019:14 [13] has been moved to area orderdata2 [410]. (8613) All indexes associated with table order.order_2019:14 [13] have been moved to area orderindex2 [411]. (8614) proenv>
Задание выполнено!