SAP Knowledge Base Article - Preview

3788237 - Multi-level Range-Hash partitioning of ACDOCA table

Symptom

ACDOCA is partition based on SAP recommendation - FISCYEARPER as range.

Create  multilevel partition to avoid 2 billion limit decided to choose BELNR & HASH 4 partition to have 500 million in each partition. 

but getting the following error :

Could not execute 'ALTER TABLE "SAPSS4"."ACDOCA" ADD PARTITION RANGE ("FISCYEARPER") ( (PARTITION VALUE = '#######') ...' in 12 ms 615 µs . 
SAP DBTech JDBC: [7]: feature not supported: add partition for non-HETEROGENEOUS partitioned table 

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental"


Read more...

Environment

SAP HANA 2.0, platform edition

Product

SAP HANA, platform edition 2.0 ; SAP S/4HANA 2023

Keywords

feature not supported: add partition for non-HETEROGENEOUS partitioned table ; ACDOCA;  PARTITION;  RANGE-HASH;    , 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.