Search for the current scn value in oracle flashback

Oracle flashback searches for the current scn value 1. find the current scn value SELECT dbms_flashback.get_system_change_number from dual; assume the returned value is 140856480 2. count or view the record of the current scn value SELECT count (*) from qt_exame_ver as of scn 140856480; SELECT * from qt_exame_ver as of scn 140856480; 3. count or view the record of the current scn value SELECT count (*) from qt_exame_ver as of scn 140856000; SELECT * from qt_exame_ver as of scn 140856000; always find an appropriate scn value, assuming: 140848000 4. to enable the row movement function, only the row movement function can be enabled to flash back to alter table qt_exame_ver enable row movement; flashback table qt_exame_ver to scn 140848000; if the row movement function is not supported, you can manually insert into qt_exame_ver SELECT * from qt_exame_ver as of scn 140848000 where msg_id = 18838;