Re: detect changes on a table

Artturi <artturi.nospam_at_free.fr> wrote in message news:<41573258$0$17118$636a15ce_at_news.free.fr>...
> Hello,
>
> I have to create a database (A) based on the content of another one (B,
> hosted on oracle) which hosts informations on students (and driven by a
> commercial application).
> If it will be simple to populate db A initially, I don't see a way to keep
> the data in sync with B as updates will occur.
>
> Do someone here have an idea about that ?
> Is there a way to detect updated records for a given table ?
>
> Thanks in advance,

Hi,

if both A and B are hosted under the same Oracle Version look for 'Standby database technique' and have a DBA at your side that has this skill.
It's synchronized via the archive logs of the primary database (B) to the standby database (A).

yk Received on Mon Sep 27 2004 - 08:40:12 CDT