SAP Knowledge Base Article - Preview

3290785 - Feature not supported: cannot MOVE table or partition with NOT MOVABLE option

Symptom

While moving a table to another location by executing the following SQL commands:

ALTER TABLE "<SCHEMA_NAME>"."<TABLE_NAME>" MOVE PARTITION <ALL_PART_IDs> PHYSICAL;
eg:
ALTER TABLE "<SCHEMA_NAME>"."<TABLE_NAME>" MOVE PARTITION 1 PHYSICAL;
ALTER TABLE "<SCHEMA_NAME>"."<TABLE_NAME>" MOVE PARTITION 2 PHYSICAL;
ALTER TABLE "<SCHEMA_NAME>"."<TABLE_NAME>" MOVE PARTITION 3 PHYSICAL;
ALTER TABLE "<SCHEMA_NAME>"."<TABLE_NAME>" MOVE PARTITION 4 PHYSICAL;

The database error below could occur: 

"feature not supported: cannot MOVE table or partition with NOT MOVABLE option".


Read more...

Environment

SAP HANA, platform edition 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

MOVABLE, NOT MOVABLE, MOVE table, MOVE table or partition, IS_MOVABLE, SET MOVABLE, cannot MOVE table or partition with NOT MOVABLE option , KBA , HAN-DB , SAP HANA Database , Problem

About this page

This 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.