Flashback Data Archive - Truncate Table - FDA operation is not 'DELETE'
"Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.6.0.0.0"
Using FDA (Flashback Data Archive), I am trying to build a history table with all operations like Inserts, Updates and Deletes on a table. I am able to capture traditional I, U and D operations on a simple table ( No IOTs). But when the table is truncated, the record is not appearing as Operation = ‘D’ when I use VERSIONS BETWEEN syntax. Do you suggest how to perceive the records as ‘Delete’ when truncate operation happens on the table using FDA VERSIONS BETWEEN syntax.
create table test_truncate_tab ( col1 number) flashback archive;