An administrator attempts to issue the command FLASHBACK TABLE hr.employees TO TIMESTAMP SYSTIMESTAMP - INTERVAL '10' MINUTE. The command fails…

The FLASHBACK TABLE command reverts a table to a past state. This operation may require moving rows between data blocks to restore their previous state, for example, if rows were deleted and their space was reclaimed. The ORA-08189 error explicitly states that this is not possible because row movement is disabled for the target table. To permit Oracle to move rows as needed during the flashback operation, row movement must be explicitly enabled on the table using the ALTER TABLE ... ENABLE ROW MOVEMENT command.

A. ROWMOVEMENT is not a system-level parameter; it is a table-specific property and cannot be set with ALTER SYSTEM.

C. FLASHBACK ON is not a valid clause for the ALTER TABLE statement in this context. Flashback capabilities are managed differently.

D. ALTER TABLESPACE ... FLASHBACK ON is used for Flashback Database, which is a separate feature operating at the database level, not for individual table flashback.

1. Oracle Database SQL Language Reference, 23ai. "FLASHBACK TABLE". The prerequisites section states: "To flash back a table, you must have the FLASHBACK object privilege on the table or the FLASHBACK ANY TABLE system privilege. You must also have SELECT, INSERT, DELETE, and ALTER object privileges on the table. In addition, you must enable row movement on the table (ALTER TABLE...ENABLE ROW MOVEMENT)."

2. Oracle Database Administrator's Guide, 23ai. "Flashing Back a Table to a Point in Time". The section "Prerequisites for Using Flashback Table" explicitly lists: "Row movement must be enabled on the table for which you are issuing the FLASHBACK TABLE statement."