Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: detect changes on a table

Re: detect changes on a table

From: crumedgeon <zimsbait_at_hotmail.com>
Date: Sun, 26 Sep 2004 20:48:10 -0400
Message-ID: <MZudndclLv9J_8rcRVn-pg@adelphia.com>


You can also use triggers through a database link or Materialized views. Of course, this is based on your db version and access to remote db.

"Hans Forbrich" <news.hans_at_telus.net> wrote in message news:7IG5d.117182$KU5.111865_at_edtnps89...
> 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 - 19:48:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US