Re: Ideas Required

One way would be to use database triggers. They come is all sorts of flavors, but you would have to do a lot of coding to get what you wanted for every table.

"Daniel Vaughan" <dan_at_w2s.net> wrote in message news:994071490.16433.0.nnrp-01.c1ed3344_at_news.demon.co.uk...
> 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
>
>
Received on Mon Jul 02 2001 - 14:12:33 CDT