ORACLE recovers deleted data

Tag:io    use    for   on    data    ef    amp   as    time    

/*1.flashback query*/--flash back 15 minutes ago Select * from orders as of  timestamp (systimestamp-interval "" Minute ")  where ... You can replace minute with day, SECOND, month, for example: SELECT * from orders as of TIMESTAMP (Systimestamp-interval ' 2 "day)--flash back to a point in time Sele CT  * from  orders  as of timestamp to_timestamp (' 01-sep-04 16:18:57.845993 ', ' Dd-mon-rr HH24:MI:SS. FF ') where ...-flash back two days ago select * from orders as of  timestamp (sysdate-2) where .../*2.flashback drop*/   1. Flashback table orders to before drop;     2. If the source table has been rebuilt, you can use the Rename to clause:   Flashback table order to before drop  rename to order_old_version;   /*3.flashback table*/   1. First, to enable row migration:   alter TABLE order enable row movement;   2. Flash back to 15 minutes ago:   Flashback Table order to  timestamp systimestamp-interval ' "minute;     Flash back to a point in time:   FLASHBACK TABLE order to TIMESTAMP    to_timestamp (' 2007-09-12 01:15:25 PM ', ' yyyy-mm-dd HH:MI:SS AM ')

ORACLE recovers deleted data