delete清空表操作:
flashback table tableName to timestamp to_timestamp('2017-12-28 16:00:00','yyyy-mm-dd hh24:mi:ss');
备注:上面时间为数据所要恢复的时间点,若提示 cannot flashback the table because row movement is not enabled,则先执行 alter table tableName enable row movement; 语句,再执行上面语句。
drop删除表操作:
flashback table tableName to before drop;