Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Synchronization question.
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
create materialized view ...
Richard Kuhler Received on Tue Sep 30 2003 - 19:17:45 CDT