Sometimes in production servers, you might need to check specific record(s) in order get older versions. Oracle has Flashback technology to revert your datas to a specific SCN or timestamp. In order to use it, Flashback option should be enabled. After enabling, Oracle will start to save tables at specific times.
SELECT * FROM <table_name> AS OF TIMESTAMP(SYSDATE - INTERVAL '10' MINUTE);The query above shows you the table’s older version. You can also narrow results with a WHERE clause:
SELECT * FROM <table_name> AS OF TIMESTAMP(SYSDATE - INTERVAL '10' MINUTE) WHERE proc_id = 3843;