读书人

数据库闪来

发布时间: 2012-11-22 00:16:41 作者: rapoo

数据库闪回
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')

读书人网 >其他数据库

热点推荐