Data_loss_issue

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
MIHIR KAR#Oracle_DB #UNIX beginnerAsked:
Who is Participating?
 
slightwv (䄆 Netminder) 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
0
 
Pawan KumarDatabase ExpertCommented:
Hi Mihir,

You cannot rollback a committed transaction but there is a concept of Flashback query , pls see if that helps.
0
 
Pawan KumarDatabase ExpertCommented:
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

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Pawan KumarDatabase ExpertCommented:
0
 
Pawan KumarDatabase ExpertCommented:
MIHIR,

I also gave you the same thing but you have not accepted my comment. Why is like that ?
0
 
MIHIR KAR#Oracle_DB  #UNIX beginnerAuthor Commented:
Oho... my bad !! Sorry Pawan,  i was missed, your comment also was correct .
0
 
Pawan KumarDatabase ExpertCommented:
Not a problem , Please inform the moderators, they will reopen the question for you and then you can choose answers again. Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.