–闪回 回退已删除的数据 select * from ncms_specialist_chronic as of timestamp to_timestamp(‘2019-12-16 9:04:00’, ‘yyyy-mm-dd hh24:mi:ss’); –开启这张表的状态 alter table ncms_specialist_chronic enable row movement; flashback table ncms_specialist_chronic to timestamp to_timestamp(‘2019-12-16 9:04:00’, ‘yyyy-mm-dd hh24:mi:ss’); –关闭 alter table ncms_specialist_chronic disable row movement;
测试1
上一篇
2022年3月22日