数据表被误删的恢复方法

来源:互联网 发布:淘宝三星s8 编辑:程序博客网 时间:2024/06/04 01:16

--查看以前的记录
--5分钟以前
SELECT * FROM def_setting as of timestamp (systimestamp -interval '5' minute);

--5小时以前
SELECT * FROM def_setting as of timestamp (systimestamp -interval '5' hour);

--1天以前
SELECT * FROM def_setting as of timestamp (systimestamp -interval '1' day);