You use a Flashback Transaction Query to obtain transaction information, including SQL code that you can use to undo each of the changes made by the transaction.
Let us exploit it with an example….
At this point,
depthave one row each. In terms of row versions, each table has one version of one row. Next, suppose that an erroneous transaction deletes employee id
Subsequently, a new transaction reinserts employee id
111with a new employee name into the
At this point, the DBA detects the application error and needs to diagnose the problem. The DBA issues the following query to retrieve versions of the rows in the
emptable that correspond to empno
SELECT xid, start_scn START, commit_scn COMMIT,