Re: PL/SQL on multiple databases/users

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Tue, 24 Dec 2002 06:56:42 -0800
Message-ID: <3E0875AA.A906B24E@exesolutions.com>

Emo Ludovic wrote:

> Hello,
>
> I have 5 users having the same schema (same tables, same constraints, ...)
> not on the same physical server.
>
> I need to synchronize some content (some lines of some tables) between
> thoses users, with some handling on the datas (recalculate ids, ...)
>
> Do you know if in PL/SQL, I can read datas on one of the user
> and alter (insert/update/delete) on another user consequently
>
> I mean having two connections on two servers/databases/users opened at
> the same time.
>
> Thanks in advance.

Go to http://tahiti.oracle.com and search on "DATABASE LINK" and "MATERIALIZED VIEW" There are more elegant ways to synchronize but I suspect they would be more effort than they are worth in your case.

Daniel Morgan Received on Tue Dec 24 2002 - 08:56:42 CST