ORACLE Data Recovery

--Retrieve data from one hours ago

SELECT * from sys_system_dictionary as of timestamp sysdate-1/24
ORDER BY ID

The use of the as of timestamp method is very convenient, but in some cases we recommend using the as of SCN to execute flashback Query. If you need to restore multiple tables with primary foreign key constraints, if you use the as of timestamp, the data selection or insertion failure may be caused by inconsistent time points, and the as of SCN ensures that the recording processing time is consistent.

ORACLE Data Recovery