ora_archive_state + dbms_redefinition
I have an idea on how to implement a massive data cleanup of a complex database schema.
At first stage, the procedure would update tables setting ora_archive_state='1' using batches, iterating trough parent-child relationships.
At the second stage, dbms_redefinition would reorganize tables one-by-one getting rid of archived rows.
The problem is, dbms_redefinition does not support meaningful handling of ora_archive_state.
While trying to reorganize table with "row archival", dbms_redefinition just makes all rows of the resulting table unarchived.
What do you thing, would there be any sense to ask for an enhancement to dbms_redefinition to handle in-database row archiving?