闪回操作

1. 闪回版本查询：

1.1 查询时间定点数据库集合

select * from table as of timestamp to_date('2010-01-02 12:12:22','yyyy-mm-dd hh24-mi-ss');

1.2 查询表操作 版本查询

select versions_starttime vst_time,versions_startscn vst_scn,versions_endtime vend_time,versions_endscn vend_scn,versions_xid vxid,

versions_operation vop,id,name

from tbl_program versions between scn minvalue and maxvalue where versions_operation='U'

1.3 闪回数据查询

select * from flashback_transaction_query where table_name='TBL_PROGRAM' and operation='UPDATE'