- 查看回收站
select * from recyclebin; - 闪回
flashback table table_name to before drop; - 基于时间的查询(as of timestamp)
INSERT INTO FLASH_TBL SELECT * FROM FLASH_TBL AS OF TIMESTAMP SYSDATE-5/1440 WHERE ID<10;
对于有主外键约束的表进行备份,使用as of scn
数据回滚
最新推荐文章于 2023-11-16 17:12:52 发布