Re: Running two databases stimutaneously

In article <4ceiqt$ida_at_govonca3.gov.on.ca>, warren_at_admin.flarc.edu.on.ca writes:
>Can anyone tell me the best way to run to databases located on two
>different nodes stimutaneously. What I want is to access the one and when
>an update is done it immediately reflects on the other database. I believe
>I cannot use the Parallel Server because of the different platforms..one
>node being on a vax node and the other is on a alpha node. I am currently
>running oracle 7.1 open vms 6.1 on the alpha and 7.0, 6.1 on the vax. The
>nodes are not clustered. Currently both instances run in exclusive mode.
>Does anyone have any ideas on how to approach this .....
>thanks in advance
>Karen....
If anyone is interested I found out a few tidbits that resolved my dilemma.. I did forget to mention that I have sqlnet up and running... 1) cant use parallel server for reasons above. 2) I could set up database links and write sql update statements including the

   group name but unfortunately the forms are not our own so we cannot modify    the code.
3) Table replication or using snapshots would resolve the problem but I need

   7.1 at both ends.
4) I could use db triggers but I decided to write a nightly script and update

   using sqlnet...

If anyone has ideas, suggestions or a better approach ??? thanks   Received on Thu Jan 04 1996 - 00:00:00 CET