Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Recovering deleted rows from oracle table

Tags:

oracle

Is this possible to recover the deleted rows from oracle table? My data is stored in a table MANUAL_TRANSACTIONS. Schema name is CCO.I have accidentally deleted some 500 Thousands rows in a table and did the commit too. Now I want to recover them.I am using Oracle 11g R2.Thanks

like image 849
santhosha Avatar asked Apr 28 '14 06:04

santhosha


1 Answers

You can recover the details using Oracle Flashback Query. You could query the contents of the table as of a time before the deletion to find out what data had been lost, and, if appropriate, re-insert the lost data in the database. Here's the sample query:

select * from MANUAL_TRANSACTION as of timestamp to_timestamp('28-APR-2014 12:30:00', 'DD-MON-YYYY HH:MI:SS') where ' clause based on your deleted data';

Source: http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr002.htm

like image 60
Ravi. Avatar answered Oct 13 '22 20:10

Ravi.