闪回表

查询需要闪回的时间的scn:

select timestamp_to_scn(to_timestamp('2016-01-11 10:00:00','yyyy-mm-dd hh24:mi:ss')) as scn from dual;

 

如下为执行

SQL> flashback table yky.website to scn 4432168706;
flashback table yky.website to scn 4432168706
                        *
ERROR at line 1:
ORA-08189: 因为未启用行移动功能, 不能闪回表?

 

SQL> alter table yky.website enable row movement;

Table altered.

SQL> flashback table yky.website to scn 4432168706;

Flashback complete.

SQL>