What is Flashback Table?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to
ace your certification exam in first attempt.
Flashback Table is a command used at the SQL prompt to restore the state of a table/tables to a specific earlier point in time without using tablespace point in time recovery (a traditional method to restore tables), which is very much time consuming. It uses undo tablespace to restore the state of a table/tables to a specific earlier point in time. It undoes recent transactions on an existing table. The row movements for the table have to be enabled for the Flashback Table command to take effect. When a Flashback Table operation takes effect for a table then the rest of the database remains unaffected. The Flashback Table acquires exclusive DML locks on the tables involved in the flashback.
NOTE: The current SCN should be recorded before using the Flashback Table command.
An example of the Flashback Table command is given below:
SQL > alter table o.abc enable row movement; (This will enable row movement for the table)
SQL > flashback table o.abc
to timestamp systimestamp - interval '15' minute; (This will flashback the table to 15 minutes before the flashback)
Other articles
