Flashback Table with constraints enabled in novalidate
Hi,
I am facing a problem with the flashback table feature. In a 1.5TB database 10.2.0.4 on win64 , we load data daily from external table using the MERGE statement. In case of an issue with the data provided, we want to use the Flashback Table feature to undo the load on a group of partitioned tables. On those tables, there are some foreign key constraints enabled (novalidate). I know that during the flashback, Oracle changes the constraints to deffered and then re-enable/validate them after the flashback. First, this operation is very long due to the volume (some tables have 1.5 billion records) and secondary, we know that the constraints are no longer valid due to drop partition done to purge the data.
If I disable the constraint before the flashback operation, the alter table will invalidate the flashback table and I get the error : "ORA-01466: unable to read data - table definition has changed".
Is there a way, to have the Flashback Table to re-enable the constraint in novalidate state?
Thanks
Christophe