During alter table partition by clause, data cannot move between column store and extended storage. Error below can be found:
Alter table m10 PARTITION BY RANGE(b)
(USING DEFAULT STORAGE (PARTITION 00000010 <= VALUES < 00000050 , partition OTHERS)
USING EXTENDED STORAGE (PARTITION 00000050 <= VALUES < 00000070 ));
column store error: fail to alter partition:  Error during split/merge operation;Moving data between servers is not allowed. Partition 1 at <host_name>:<port_number> needs to be moved to <host_name>:<port_number>.,object=<object_name>
- SAP HANA DYT 1.0
- SAP HANA DYT 2.0
Moving data between servers is not allowed , KBA , HAN-DYT , SAP HANA Dynamic Tiering , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.