[Oracle] Should I Use LogMiner or Flashback?

Use Case/Scenario:

You have an Oracle database that you want to ingest through Fivetran, but don’t know whether to choose LogMiner or Flashback as your incremental update mechanism.

Fivetran Recommendation:

• Fivetran recommends choosing Flashback as your incremental update mechanism in all cases

The only exception to this is the following scenario:

• Your Oracle database contains LONG data types that cannot be converted to a LOB

In this case, Fivetran recommends:

1. Utilise Flashback for all tables that do not contain LONG data types in one connector
2. Utilise LogMiner for all tables that contain LONG data types in a second connector
3. Ensure that Supplemental Logging has been enabled for all tables that contain LONG data types
4. Plan for an upgrade to your database to enable the conversion of LONGs to LOBs in order to migrate to a single connector utilising Flashback

Considerations:

• Enabling both Flashback Data Archive and Supplemental Logging on tables can lead to unnecessary increases in both the creation of log files and log file size; ensure that only one or the other is enabled
• LogMiner is not supported by default; please raise a ticket with the Fivetran Support team to have your connector enabled for LogMiner