Search code examples
oraclehadoopsqoop

Is it good to use oracle flash back query to get delta records?

I am trying to use Oracle flash back queries to get the delta records from the source systems using Sqoop commands.

Could someone suggest is it good approach to get the delta (insert, update, delete) ?

We followed this to enable FQ: https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS1008

Solution

  • It depends. Flashback Query will allow you to tracking history changes for a period, which depends of a lot of factors ( undo retention, level of loading, undo size ). Botton line you will never be 100% sure that you got what you want.

    If you want to be sure that you can retrieve this tracking history changes, for a determined period of time, you must configure Flashback Data Archive.

    Regards