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