Wednesday 5 September 2012

How to Flashback table to specific previous hours ,minutes or seconds


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;

No comments:

Post a Comment