Oracle数据回滚

create table test(
id int,
name varchar2(5)
)

select * from test;

insert into test (id,name) values(1,'张三');
insert into test (id,name) values(2,'李四');
insert into test (id,name) values(3,'王五');



-- 清空表内 ALL_DATA。
DELETE FROM test;
commit;

-- 查询表内数据总数。
SELECT COUNT(*) AS COUNT FROM test;

-- 执行表数据闪回（回滚）申明
ALTER TABLE test ENABLE ROW MOVEMENT;

-- 正式数据回滚
FLASHBACK TABLE test TO TIMESTAMP TO_TIMESTAMP('2019-12-20 14:24:00','YYYY-MM-DD HH24:MI:SS');