oracle 数据回滚

select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;

select * from t_payment_detail_cj as of timestamp to_timestamp('2022-09-20 16:30:12','yyyy-mm-dd hh24:mi:ss');

alter table t_payment_detail_cj enable row movement;

flashback table t_payment_detail_cj to timestamp to_timestamp('2022-09-20 16:30:12','yyyy-mm-dd hh24:mi:ss');

posted @ 2022-09-21 11:02  来去都是自由风  阅读(126)  评论(0)    收藏  举报