ORACLE删除表数据，如何闪回数据？

一、创建一个表名为orders，字段为ORDER_ID、CUSTOMER_ID、ORDER_STATUS、DATE_ORDERED

 CREATE TABLE ORDERS (ORDER_ID NUMBER(4),CUSTOMER_ID NUMBER(4),ORDER_STATUS VARCHAR(100),DATE_ORDERED DATE);

 二、orders表中添加几行数据

insert all into orders(order_id,date_ordered) values(1,sysdate) into orders(order_id,date_ordered) values(2,sysdate) into orders(order_id,date_ordered) values(3,sysdate) select 1 from dual;

 三、启用行迁移

 alter table orders enable row movement;

 四、删除表数据

delete from orders;

 五、闪回数据

闪回到五分钟前

flashback table orders   to timestamp systimestamp - interval '5' minute;

闪回某个时间点：

flashback table 表名 to timestamp to_timestamp ('2023-07-28 21:10:00','YYYY-MM-DD HH24:MI:SS';