Re: Ideas Required

Daniel Vaughan wrote:

> Hi,
>
> I have two Oracle systems (A and B) both running on 8.1.7. Both systems
> perform the same basic function for two different sets of users however the
> table structure of each database is different and the database run
> independently.
>
> I would like to acheive the following.
> - A user creates/modifies/deletes a record on database A. Somehow I
> would like the change to also appear in database B also in the correct
> format automatically and in realtime.
>
> My knowledge of databases is good but specific knowledge of Oracle limited.
> I assume you would place something in the middle to convert the data and
> implement the change. Could anyone suggest a way of doing this/ a product/
> or even an approaching/right place to look for more info on acheving this.
>
> King Regards
>
> Dan

There are a number of potential solutions. Can you create a database link between them? If so a stored procedure can easily accomplish this goal.

Daniel A. Morgan Received on Sun Jul 22 2001 - 08:55:25 CEST