●误删数据闪回
select first_page_submit_user_id from PAT_VISIT as of timestamp(systimestamp - interval '30' minute ) WHERE PATIENT_ID='00003460';
drop table后找回数据
select * from user_recyclebin where DROPTIME >'2018-11-20 15:00:00';
flashback Table "BIN$exRnNvh6nmzgUxMPCgoueg==$0" to before drop
●查看某个时间点表数据
select * from sys_authority as of timestamp to_timestamp('2013-07-16 14:48:00','yyyy-mm-dd hh24:mi:ss')
●恢复表到某个时间点
ALTER TABLE jhmr_templet_content ENABLE ROW MOVEMENT;
flashback table jhmr_templet_content to timestamp to_timestamp('2020-04-02 16:45:00','yyyy-mm-dd hh24:mi:ss');
flashback table sys_authority to timestamp to_timestamp('2013-07-16 14:40:00','yyyy-mm-dd hh24:mi:ss');
数据库误删数据回到删除时间
最新推荐文章于 2024-09-15 01:19:00 发布