<div>
Hi Mihir,<br />
<br />
You cannot rollback a committed transaction but there is a concept of Flashback query , pls see if that helps.
</div>


Hi Mihir,

You cannot rollback a committed transaction but there is a concept of Flashback query , pls see if that helps.

<div>
Sample flash query for you -<br />
<br />

<pre><code id="code-20-42354484-1">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</code></pre>
</div>


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

<div>
Also read this FLASHBACK TABLE ( from oracle )<br />
<br />
<a href="https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9012.htm" rel="ugc">https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9012.htm</a>
</div>


Also read this FLASHBACK TABLE ( from oracle )

https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9012.htm [https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9012.htm]

<div>
MIHIR,<br />
<br />
I also gave you the same thing but you have not accepted my comment. Why is like that ?
</div>


MIHIR,

I also gave you the same thing but you have not accepted my comment. Why is like that ?

<div>
Oho... my bad !! Sorry Pawan, &nbsp;i was missed, your comment also was correct .
</div>


Oho... my bad !! Sorry Pawan,  i was missed, your comment also was correct .

<div>
Not a problem , Please inform the moderators, they will reopen the question for you and then you can choose answers again. Thanks
</div>


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

<div>
<div class="content wysiwyg-content">
Is there any way to rollback a committed transaction in oracle 11g<br />
<br />
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?<br />
<br />
Please share a optimal solution .<br />
<br />
thanks in Advance
</div>
</div>


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

Data_loss_issue

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.