<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>


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

<pre><code class="code-1 nolinks" id="code-20-42354484-1"><span>INSERT INTO yourtable </span>
<span>SELECT * FROM yourtable as of timestamp timestamp '2018-11-04 08:59:54' /* you need to pass the date and time */</span>
<span>MINUS</span>
<span>SELECT * FROM yourtable</span>
</code></pre>
</div>


<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>


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


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


<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>
<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.