I have this doubt from a very long time. Searched for it a lot in internet but could not find it.
I need to know the behavior of extract when I perform below commands.
add extract <extract_name>, tranlog begin now
&
start extract <extract_name>
For example:
- I added the extract as below as 2:00 PM.
add extract <extract_name>, tranlog begin now
- Then from 2:00 PM to 4:00 PM. I insert some new data(around 20 records)
- Then at 4:00 PM , I start the extract
start extract <extract_name>.
So, when I start the extract, from what time it will start reading the changes happened in the database? Is it from 2:00 PM or 4:00 PM?