oralce单个表中数据回滚

DELETE FROM T_USER;
INSERT INTO T_USER
       SELECT *
       FROM T_USER AS OF TIMESTAMP 
       TO_TIMESTAMP('2021-01-19 09:06:00', 'yyyy-mm-dd HH24:mi:ss')--回滚到某个时间
COMMIT;

 

posted @ 2021-01-26 19:50  Kavins  阅读(132)  评论(0编辑  收藏  举报