oracle 数据误操作数据恢复

oracle 数据误操作数据恢复

select * from table as of timestamp to_timestamp('2012-02-02 16:00:00,'YY-MM-DD hh24:mi:ss')

 insert into table select * from table as of timestamp to_timestamp('2012-02-02 16:00:00,'YY-MM-DD hh24:mi:ss')

转载于:https://blog.51cto.com/remotesensing/771279