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 ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.