SAP Knowledge Base Article - Preview

2487081 - OFFSET and LIMIT compatibility with SAP HANA Smart Data Integration


You have created a virtual table in Hana using the SDI OracleLogReader Adapter. You set a task to ransfer the data from Oracle to Hana via an Hana Insert statement using OFFSET and LIMIT. However, the loading the test table fails in Hana on an Out-Of-Memory exception.



  • SAP HANA Smart Data Integration
  • OracleLogReader Adapter


SAP HANA 1.0 smart data integration ; SAP HANA smart data integration 2.0


HAN-DP-SDI, DP, Data Provisioning, 11g, Rownum , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , 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.