Re: Table changes

From: Mathias Magnusson <mathias.magnusson_at_gmail.com>
Date: Tue, 28 Apr 2009 06:43:57 +0200
Message-ID: <8580d4110904272143y72a17721lee8724280fe0de49_at_mail.gmail.com>

I think you have the key ones there. I can think of a few other possible way, but they are probably not what you want to use.

1. Change Data Capture
2. Log Miner
3. Not having the table in D2, but use a link to select from D1 instead.
4. Merge statement reading data from D1 and comparing to D2
5. Datapump (would need to identify what data to move)
6. Trigger on D1 populating D2 (not staging, but the actual table).
7. Transportable tablespace.

What you want will of course depend on your need in D2. Is it select only? If not, are changes being moved back to D1?

Mathias

On Mon, Apr 27, 2009 at 10:48 PM, Kumar Madduri <ksmadduri_at_gmail.com> wrote:

> Hi
> There are two tables in two databases. If change is made on the source
> table in database 1, then I should be able to pick up the change in
> the destination table on database 2 and run my program which is based
> on the changes made to this table.
> For example, I can have a table with these values in T1 on database d1
>
> name department salary
> kumar 10 123
> scott 20 456
>
>
> and T2 on database d2 has
>
> name department salary
> kumar 30 123
> scott 20 456
>
> So only Kumar's record should be picked up on the destination as a
> list of records to be processed. Bascially the changed records need to
> be picked up and some data processing is done.
>
> Things that I think would achieve this are
> 1. Streams
> 2. Materialized views
> 3. Trigger on source and populating a staging table.
>
> Is there any other way that can be used?
>
> Thank you
> - Kumar
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 27 2009 - 23:43:57 CDT