location transparency / replication

From: Willy Klotz <willyk_at_kbigate.stgt.sub.org>
Date: Tue, 13 Dec 94 22:37:35 GMT
Message-ID: <787358255snx_at_kbigate.stgt.sub.org>

If I have a distributed database (across 2 or more nodes) and want to implement location transparency (so that the application does not know where the tables actually are stored), I can do this defining synonyms pointing to the different oracle instances.

Is it possible to use replicated tables in this environment ? And to do inserts / updates on the tables without modification of the application ?

What I want to do is something like this:

Database A                         Database B

Table_ONE ---replicated to ---> TABLE_ONE

    ^                                  I
    I                                reads
    I                                  I
    I                                  V

    +-------< --- updates ------ Application

If this is _not_ possible, what other options do I have ?

Willy Klotz

---

Willys Mail     FidoNet   2:2474/117  2:2474/118     Mail Only System
                CIS: 100020,3517       USR Courier HST dual standard
                willyk_at_kbigate.stgt.sub.org


                ->   No Request from 06.00 to 08.00 <-


======================================================================

Received on Tue Dec 13 1994 - 23:37:35 CET