cancel
Showing results for 
Search instead for 
Did you mean: 

partition (1) contains *** records. A table partition cannot contain more than 2,147,483,64

SAPSupport
Employee
Employee
0 Kudos
115

The Table S*** has 2 partitions as we are reaching 2Billion mark, but we are observing that the Partition-1 of the the table is still increasing by few entries everyday. it is very close to 2Billion records and we would need suggestion on the house keeping for this table to keep the entries under the limit.Please find the screenshot of Historical Growth based on Daily Data: 


------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.
View Entire Topic
SAPSupport
Employee
Employee
0 Kudos

Review this note below and perform a reorg for large table as mentioned in note:

2374652 - Handling Very Large Data Volumes in SAP BW/4HANA
-> Handling Large Data Volumes - 2 Billion Limit Value Reached

As a remind that you need apply file TABLE_PLACEMENT.zip before the reorg as mentioned in this note.