Regarding Oracle SQL*Loader's Direct-Path INSERT.

[iti-attunity-sup]

Hello Support Team,

I hope you are doing well.

I would like to clarify the recommended settings when the source database uses Oracle SQL*Loader's Direct-Path INSERT.

My understanding is that because Oracle SQL*Loader's Direct-Path INSERT writes blocks directly to the disk without going through the buffer cache,
it does not generate REDO logs or archive log files.
Therefore, if we want to ensure REDO logs are generated, we need to either enable the table's LOGGING setting or switch to FORCE LOGGING mode.

Based on this, I assumed that Qlik Replicate would not be able to perform CDC on data inserted into the source DB via Oracle SQL*Loader's Direct-Path INSERT.
However, upon reviewing the limitations, I could not find any specific limitations or recommendations regarding Direct-Path INSERT.

Are there any recommended settings on the source Oracle database side when using Oracle SQL*Loader's Direct-Path INSERT?

Best regards.

[iti-attunity-sup]

Hello Support Team,

Based on our internal verification, data was successfully synchronized when the table's LOGGING setting was set to YES.
However, when the table's LOGGING setting was set to NO, the data could not be synchronized.

Aside from verifying whether the table's LOGGING setting is set to YES,
are there any other potential impacts on CDC or points of caution (such as limitations or concerns) that we should be aware of when using Oracle SQL*Loader's Direct-Path INSERT?

Best Regards.