oracle数据库不小心删除或者增加了非法的数据,想将数据回退到之前时间的版本,sql语句如下
delete from table_name;
INSERT into table_name select * from 表名 as of timestamp to_timestamp('2018-11-27 00:00:00','yyyy-mm-dd hh24:mi:ss');
oracle数据库不小心删除或者增加了非法的数据,想将数据回退到之前时间的版本,sql语句如下
delete from table_name;
INSERT into table_name select * from 表名 as of timestamp to_timestamp('2018-11-27 00:00:00','yyyy-mm-dd hh24:mi:ss');