Re: Synchronization question.

If you are just concerned about these two tables, then a trigger will do the trick. When the table in the first db undergoes DML, the trigger should fire and make the same DML change in the second db's table.

If you are using Oracle 9i, and this will get more complex, then have a look at Oracle Streams.

Thanks,
Brian

Konstantin Grudnev wrote:
>
> Dear, All !
>
> I have a question. Suppose I have two databases first called FIRSTDB,
> second called SECONDDB, in FIRSTDB database I have table FIRSTTABLE
> with columns called
> JOBNAME, JOBDATA, in SECONDDB database I have table SECONDTABLE with
> columns called RABNAME, RABDATA. Fields name cannot be changed. So the
> question is the next: what is the simplest way to synchronize these
> two tables in separated databases with different tables names and
> different columns names.
>
> Desired situation:
> Suppose I wrote some data to FIRSTTABLE of FIRSTDB database, this
> wroten data should appear as soon as possible in SECONDTABLE of
> SECONDDB database. How can it be done without using third-party tools
> and without using external Oracle tools.
>
> Simply saying I want mapping between different tables of different
> databases.
>
> Thanks in advance.
> Kostya

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"