I was searching information about flashback yesterday for updates to the course material for the SANS 6-day hands on Securing Oracle track (SECURITY 509: Securing Oracle
) and came across a post to the Amis blog about flashback titled "Right a Wrong in 10g - Undo transactions using FLASHBACK_TRANSACTION_QUERY
" and written by Lucas Jellema. This is an excellent post giving some good examples of the use of the UNDO_SQL column and also the psuedo columns versions_startscn, versions_endscn, versions_operation and versions_xid available in 10g. Lucas gives some good example code and also some insight into flasback that is not the same as the usual papers on the subject.