Re: How to enable remote data manipulation?

Can be done either through triggers or through replication. Drawback of trigger: if the remote update fails the complete transaction will fail. Replication is inherently asynchronous. However you could of course choose to refresh your snapshots often. The basic idea with respect to replication is one site is the master site, the others are slaves. Multi master is possible but I don't know how that works.

Regards,

Sybrand Bakker, Oracle DBA

<ibm_97_at_yahoo.com> wrote in message news:8bgakh$6n0$1_at_nnrp1.deja.com...
> Oracle 8i for solaris 2.6
>
> How can I enable remote data manipulation automatically? I mean, if I
> do a 'update & commit' against table A in database D1, I want the same
> table A in remote databse D2 also be updated and commited.
>
> Just create a database link between D1 and D2? Or there's other
> requirements.
>
> Thanks!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Mar 24 2000 - 00:00:00 CST