is there any chance to canceland the commit command and recall the previous data in oracle?

0 ⤊

is there any chance to canceland the commit command and recall the previous data in oracle?

2006-08-09 01:23:34 · 3 answers · asked by saji c 1 in Computers & Internet ➔ Software

3 answers

Your dba could use logminer to undo the change - if the redo log files or archived log files have not moved beyond the change.
But as a statement in the session after the commit - no.

2006-08-10 16:31:49 · answer #1 · answered by oohhbother 7 · 0⤊ 0⤋

Once you commit there is no way to recover the old data UNLESS you set a SAVEPOINT.

2006-08-09 09:35:55 · answer #2 · answered by a_talis_man 5 · 0⤊ 0⤋

try rollback

2006-08-09 08:31:14 · answer #3 · answered by Anonymous · 0⤊ 0⤋