Re: detect changes on a table

Artturi wrote:

> 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,

What version of database(s)? What access do you have to the data in B?

Possibilities that come to mind without thinking include:

Advanced Replication
Streams

Docco on these for Oracle9i available at http://www.oracle.com/pls/db92/db92.homepage Received on Sun Sep 26 2004 - 16:41:23 CDT