Symptom
You want to perform table distribution/redistribution (e.g., because of partitioning a table), but the table is not partitioned.
Command (structure):
CALL REORG_GENERATE(<algorithm integer>, <optional parameter string>);
CALL REORG_EXECUTE(<plan_id>)
Example command:
CALL REORG_GENERATE(6,'GROUP_NAME=>TABLEGROUP_NAME1');
CALL REORG_EXECUTE(?);
The steps completed successfully but the table is not partitioned.
select * from m_cs_tables where table_name = ' TABLE_NAME1' - - > not partitioned PART_ID = 0
Read more...
Environment
SAP HANA, platform edition 2.0
Product
Keywords
partition, partitioning, partitioned, table, SAP HANA, saphana, SAP BW on SAP HANA, database, DB, table distribution, table redistribution, table re-distribution, CALL REORG_GENERATE, CALL REORG_EXECUTE, IS_GROUP_LEAD, GROUP, LEAD, flag, OLD_PARTITION_SPEC, NEW_PARTITION_SPEC, reorg_plan , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , 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.
SAP Knowledge Base Article - Preview