–闪回
select *
from inv_system_items as of timestamp to_timestamp(‘2019-06-26 23:00:00’, ‘yyyy-mm-dd hh24:mi:ss’);
–回退数据
flashback table testtable to timestamp to_timestamp(‘2019-04-18 10:30:00’,‘yyyy-mm-dd hh24:mi:ss’);
–闪回
select *
from inv_system_items as of timestamp to_timestamp(‘2019-06-26 23:00:00’, ‘yyyy-mm-dd hh24:mi:ss’);
–回退数据
flashback table testtable to timestamp to_timestamp(‘2019-04-18 10:30:00’,‘yyyy-mm-dd hh24:mi:ss’);