1、查看之前某段时间的数据是否是自己要回滚的数据。
SELECT *
FROM fm_gl_transaction_account AS OF TIMESTAMP TO_DATE('2010-09-29 10:15', 'yyyy-mm-dd hh24:mi')
2.是的话,执行下面操作
DELETE fm_gl_transaction_account;
INSERT INTO fm_gl_transaction_account
SELECT *
FROM fm_gl_transaction_account AS OF TIMESTAMP TO_DATE('2010-09-29 10:14', 'yyyy-mm-dd hh24:mi')
回滚数据
最新推荐文章于 2024-06-15 20:31:11 发布