Hosting Service

08 May 2018 | MAK Azad

How to Restore Deleted Rows in Oracle | Data Recovery

Category : Oracle | Tag : Data Recovery | Oracle |

It's a classic rookie mistake: running a delete statement without a where clause. And then committing it! Here you need to recover all the data. Using Flashback Table, you can return a whole table to an earlier state. All you need to do is run:

flashback table to timestamp ;

For example, execute:
flashback table orders to timestamp systimestamp - interval '1' hour;

And Oracle restores the table its state one hour ago. Handy if you’ve just deleted all the rows! To use this, you must enable row movement:

alter table enable row movement;

If you haven’t done this, you’ll get the following error:
ORA-08189: cannot flashback the table because row movement is not enabled

All post under category Oracle

1. How to convert number into word/text with PL/SQL
2. An Overview and Clear Understanding of Oracle REF CURSOR
3. How to query/fetch data of MS Access DB from an Oracle DB?
4. How to install Apex5 with Oracle REST Data Services in windows
5. How to Restore Deleted Rows in Oracle | Data Recovery
6. How to run an oracle job from windows batch file
7. How to convert | export oracle matrix report into M.S Excel file, oracle 11g