SLT from non-SAP (Oracle) - DEFERRABLE INITIALLY DEFERRED

[former_member192142]

Hi,

I'm trying to extract data from Oracle and load it into HANA via SLT. This works fine for some tables, but for others that do not have a primary key - not so much.

The issue is that the tables does not have a primary key, but only a unique index, but the unique index is defined as DEFERRABLE INITIALLY DEFERRED - as a result SLT will not read the table. We are looking into making the unique indexes non-deferrable, but would like to avoid changing the database.

Has anyone experiece a similar issue and found a workaround?

Thanks in advance,
Jacob

[tobias_koebler · Accepted solution]

This issue was solved with the following note: 1969025 - SLT (2011 SP05) - NON SAP - Correction 10

Best,

Tobias