oracle数据库不小心删除了数据

1.select * from SYS_DICT as of timestamp to_timestamp('2019-11-05 10:00:00','yyyy-mm-dd hh24:mi:ss');

时间点在删除数据之前,又尽量精确    sys_dict 是表名

2.insert into SYS_DICT (select * from SYS_DICT as of timestamp to_timestamp('2019-11-05 10:00:00','yyyy-mm-dd hh24:mi:ss'));

把数据重新插入

posted @ 2019-11-05 10:49  一说烟雨  阅读(718)  评论(0编辑  收藏  举报