Re: detect changes on a table

Mark C. Stock wrote:

>
> if you have privilege to create triggers on the oracle database table, you
> could track inserts/updates/deletes in an audit table, and use that as a
> basis for your refresh (sort of a build-your own snapshot synchronization)
>
> what are you data volumes? if the are not large, a simple full refresh
> might be the best bet

Thanks all again, you really helped me find a solution. I will get the rights to create triggers and an audit table, this keeping me informed of every insert/update/delete :) Regards,

-- 
Artturi