flashback table and flashback archive don't work well together in 19.3

@Jonathan Lewis

Hello,

as  @Jonathan Lewis says again and again, if you combine two Oracle features, you have to be very careful, otherwise all hell can break loose :-)

It so happened to me, whilst combining flashback table and flashback archive on Oracle 19.3

It leads so far that flashback table statments do not finish.

I've put together two test scripts

https://gist.github.com/tbo007/7187fb1d2d74a010f3999170cc015488

1. without flashback archive

The script oc_ddl_fba_test.sql creates an partitioned table with 200k rows  with rowdependencies enabled.

The script oc_dml_fba_test.sql saves the current_scn ; updates every 4th row in the table ; and does a flashback table to the saved scn.