SAP Note 2137109 - Data Object ID limit

Component : Oracle - BW ORACLE

Solution : https://service.sap.com/sap/support/notes/2137109 (SAP Service marketplace login required)

Summary :
SAP Note discusses Oracle data object id limitations in large BW systems that may potentially reach the max id value of 4254950911, triggering an ORA-00600 error and halting object creation/truncate operations. Recommendations include: distinguishing between object id and data object id, understanding unique behaviors within database operations, and proactive monitoring of id usage to avoid max value. Key solutions involve tracking trends, assessing risks with defined categories, and implementing specific SAP Notes for mitigating rapid id inflation.

Key words :
terms ora-600 [kkdlron-max-objid] [4254950911] kkdlron-max-objid reason, components bw-sys-db-ora bw oracle priority correction, oracle error ora-00600 [kkdlron-max-objid] [4254950911], database reports ora-600 [kkdlron-max-objid] [4254950911], choosen review sap note 2141912 header data released, customer component bc-db-ora oracle, data object idthe maximum regular object number, data object id versus object id, oracle datapump tool expdp/impdp, 6risk classification risk level years

Related Notes :

590370Too many uncompressed request (f table partitions)
1842044
2141912Oracle Datapump fail with ORA-01426 numeric overflow when DB object numbers greater than 2^31
1914631Central Technical Note for Oracle Database 12c Release 1 (12.1)