Flashback Query - Scenario

I have a table EMP with 8 rows at 1 pm. I insert 8 more rows at 1.30 pm and committed. What will happen in the following scenarios.

1. Flashback to 1.15 pm.

8 Rows will be displayed.

2. Drop the table at 2 pm. Flashback to 1.15 pm.

Table or View does not exist

3. Create a new table with the same name EMP and insert 4 rows at 2.30 pm. Flashback to 1.15 pm.

ORA - 08176 consistent read failure, rollback does not available.

Summary

Flashback Query uses the Undo tablespace for its operation. It will use the Object ID of the objects to get the details at the specified time. If the object is dropped then the Object ID does not exist in the data dictionary, hence it cannot flashback. You have to use the Flashback Drop Feature if you want to recover from the dropped table.

Thanks