oracle误删恢复(闪回)

• 时间节点查询

SELECT
    * 
FROM
    ST_SECRETKEY AS OF TIMESTAMP TO_TIMESTAMP( '2020-08-06 09:00:00', 'YYYY-MM-DD HH24:MI:SS' )

• 数据恢复到指定时间点

flashback table ST_SECRETKEY to timestamp to_timestamp('2020-08-06 09:00:00','yyyy-mm-dd hh24:mi:ss');