Your database has a table customers that contains the columns cust_name, amt_due, and
old_status. Exhibit: Why is it that only one update is listed by the Flashback Version Query?
A.
Supplemental logging is not enabled for the database.
B.
The undo data that existed for versions of rows before the change to the table structure is
invalidated.
C.
The db_flash3ACK_reteni:on_target parameter is set to a lower value and the undo data
pertaining to the first transaction is flushed out.
D.
Undo retention guarantee is not enabled.
E.
Flashback Data Archive is full after the first update statement.
B
Remember that DDLs that alter the structure of a table (such as drop/modify column, move table, drop partition, truncate table/partition, and add constraint) invalidate any existing undo data for the table. If you try to retrieve data from a time before such a DDL executed, error ORA-01466 occurs. DDL operations that alter the storage attributes of a table (such as PCTFREE, INITRANS, and MAXTRANS) do not invalidate undo data.