Env. 19c SE2, Flashback Time Travel
Restrictions on Flashing Back Tables
This statement is subject to the following restrictions:
- Flashback Table operations are not valid for the following type objects: tables that are part of a cluster, materialized views, Advanced Queuing (AQ) tables, static data dictionary tables, system tables, remote tables, object tables, nested tables, or individual table partitions or subpartitions.
- The following DDL operations change the structure of a table, so that you cannot subsequently use the TO SCN or TO TIMESTAMP clause to flash the table back to a time preceding the operation: upgrading, moving, or truncating a table; adding a constraint to a table, adding a table to a cluster; modifying or dropping a column; changing a column encryption key; adding, dropping, merging, splitting, coalescing, or truncating a partition or subpartition (with the exception of adding a range partition).
The highlighted is a part of Flashback if I am not mistaken? Why is it considered a restriction? This would be counterproductive if we could not flashback a table using TO TIMESTAMP.
Feedback greatly appreciated.