oracle/ORACLE 数据库回滚flashback闪回

-- 查看某个时间点的表数据
SELECT * FROM FEE_INCOME_DETAILED AS OF timestamp to_timestamp( '2020-07-16 08:30:00', 'yyyy-mm-dd hh24:mi:ss' );
-- 开启回滚
ALTER TABLE FEE_INCOME_DETAILED enable ROW movement;
-- 回滚数据到某个时间点
FLASHBACK TABLE FEE_INCOME_DETAILED TO timestamp TO_TIMESTAMP( '2020-07-16 08:30:00', 'yyyy-mm-dd hh24:mi:ss' );
-- 关闭回滚
ALTER TABLE FEE_INCOME_DETAILED disable ROW movemen