SAP Knowledge Base Article - Preview

3800221 - Choosing between offline and online table partitioning

Symptom

Table partition of a non BW table in SAP HANA database is about to reach the 2 billion record count per partition limit.

Should you run offline (standard) or online partitioning?

Since partitioning of BW tables is done via data distribution (SAP Note 2143736) the partitioning of BW tables is not subject of this question.


Read more...

Environment

  • SAP HANA platform edition

Product

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

Keywords

online partitioning, offline partitioning, standard partitioning, table partitioning, hana, downtime, exclusive lock, replication, large tables, dml activity, preproduction testing, partitioning strategy, hana db engines, minimize downtime , KBA , HAN-DB-ENG , SAP HANA DB Engines , 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.