Oracle data recovery, oracle

Oracle data recovery, oracle

Recently, I am confused about how to clear the table data in oracle.

1. Back up the current data first. It is a good habit to back up data. Remember that there must be a backup each time you operate the database.

2. select * from table name as of timestamp to_Date ('time point to be restored ', 'Time formatting ');

3. Clear the data in the current table. Back up the data first !!!

4. insert into table name select * from table name as of timestamp to_Date ('2017-05-05 18:10:00 ', 'yyyy-mm-dd hh24: mi: ss ');

In fact, before you operate on data, remember to back up all the time, so there will be no such problem. Remember, back up.