Re: detect changes on a table

"Artturi" <artturi.nospam_at_free.fr> wrote in message news:4158217d$0$23934$626a14ce_at_news.free.fr...
| 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
|

again, this is assuming you have to pull the data, that you can't use any oracle heterogeneous functionality to push the data out of oracle into your database

++ mcs Received on Mon Sep 27 2004 - 09:23:25 CDT