How to Flashback table to specific previous hours ,minutes or seconds:
1- Enable the row movement on the table
Alter table OMFX.TICKET_STATE_HIST enable row movement;
2-1 flashback table to last 15 hours image:
FLASHBACK TABLE OMFX.TICKET_STATE_HIST TO TIMESTAMP SYSTIMESTAMP - INTERVAL '15' hour;
2-2 flashback table to last 30 minutes image:
FLASHBACK TABLE OMFX.TICKET_STATE_HIST TO TIMESTAMP SYSTIMESTAMP - INTERVAL '30' minute;
2-3 flashback table to last 2 seconds image:
FLASHBACK TABLE OMFX.TICKET_STATE_HIST TO TIMESTAMP SYSTIMESTAMP - INTERVAL '2' second;