Oracle Data Recovery

Recently Fanhun the data of Oracle in the wake of his brain.

1, first put the data now have a good backup, backup is a good habit, remember every operation database must have a backup.

2. Select * FROM table name as of timestamp to_date (' Want to restore to the point in time ', ' time format ');

3, clear the current table in the data, remember to backup good!!!

4. Insert INTO table name select * FROM table name as of timestamp to_date (' 2015-05-05 18:10:00 ', ' yyyy-mm-dd hh24:mi:ss ');

In fact, before operating the data, always remember the backup, there will be no such problem, remember Oh, backup.

Oracle Data Recovery