Data_loss_issue

MIHIR KAR
MIHIR KAR used Ask the Experts™
on
Is there any way to rollback a committed transaction in oracle 11g

I have made a delete from table in db and committed it, now I want to rollback the committed change. Is there any way to do it?

Please share a optimal solution .

thanks in Advance
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
Hi Mihir,

You cannot rollback a committed transaction but there is a concept of Flashback query , pls see if that helps.
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
Sample flash query for you -

INSERT INTO yourtable 
SELECT * FROM yourtable as of timestamp timestamp '2018-11-04 08:59:54' /* you need to pass the date and time */
MINUS
SELECT * FROM yourtable

Open in new window

Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
MIHIR,

Flashback or restoring from backups to a point prior to the delete are your only options.

Mark Geerlings explained things nicely in your previous question on this subject:
https://www.experts-exchange.com/questions/29025207/Oracle-commit.html
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
MIHIR,

I also gave you the same thing but you have not accepted my comment. Why is like that ?
MIHIR KAR#Hadoop #Oracle_DB  #UNIX beginner

Author

Commented:
Oho... my bad !! Sorry Pawan,  i was missed, your comment also was correct .
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
Not a problem , Please inform the moderators, they will reopen the question for you and then you can choose answers again. Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial