Search BC Sites

Free Oracle Tips   HTML Text

Free Oracle App Server Tips   HTML Text

Privacy Policy

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Easy Oracle Automation
Chapter 7 - Application and SQL Management

Flashback Table

The effects of a FLASHBACK TABLE command can be undone by issuing another FLASHBACK TABLE command with the appropriate SCN or timestamp. The v$database view can be queried to obtain the current SCN value represented in the CURRENT_SCN column.

Triggers are disabled by default for the duration of a Flashback Table operation. After the Flashback Table operation is completed, the triggers are returned to the state prior to the flashback operation.

The Flashback Table is an efficient operation to easily and quickly recover from erroneous user modifications done without DBA involvement. This is significantly better than media recovery in terms of speed, availability, and ease of recoverability.

Flashback Table operations consider the integrity of data before doing any changes to the database tables. When a FLASHBACK TABLE command is issued, the database checks for referential integrity constraint violations and aborts the operation if any are found. This can be avoided by flashing back multiple tables to the same point using a single FLASHBACK TABLE command.

The DBA can use the ENABLE TRIGGERS option of the FLASHBACK TABLE command to override the default disabling of triggers. This will enable all the triggers for the table. The ALTER TRIGGER command can be used to selectively disable triggers before using the ENABLE TRIGGERS option of the FLASHBACK TABLE command. Triggers that are disabled with ALTER TRIGGER remain disabled.

For more details and scripts, see my new book " Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot.