日期:2014-05-16  浏览次数:20559 次

数据库闪回
ALTER TABLE TB_ITEM_INFO ENABLE row movement;


flashback table TB_ITEM_INFO to timestamp to_timestamp('2012-11-19 10:30:00','yyyy-mm-dd hh24:mi:ss');


select *  from  tableName  as of timestamp to_timestamp('2009-01-25 12:00:00', 'yyyy-mm-dd hh24:mi:ss')