How to rollback my DB changes after a commit?

+1 vote
asked Oct 29, 2015 in Others by user234 (980 points)
I did a DB update without using a where clause and commit without taking any backup. All the rows in the table are updated. Is there any way to rollback the changes?

The DB is a Oracle SQL one. Please help.

1 Answer

+1 vote
answered Oct 29, 2015 by Admin (1,860 points)
selected Oct 29, 2015 by user234
Best answer

You could do it using Flashback feature.

commented Oct 29, 2015 by user234 (980 points)
thanks for help it saved the day
Welcome to I Can Crack, where you can ask questions and receive answers from other members of the community.

68 questions

47 answers


5,318 users