Re: Master/master with diff username possible ?

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Sun, 05 Aug 2001 08:45:46 -0700
Message-ID: <F001.00360E12.20010805082553@fatcity.com>

Henrik,

Multi-master replication requires that the schemas be identical on all sites. In addition you cannot replicate within the same site.

9i now allows updatable snapshots of updatable snapshots although it has the same restriction as multi-master in that the schemas must be identical. I believe it also has the restriction that you cannot replicate within the same site.

I'm assuming that by replicating from one schema to 3 schemas you were referring to replicating within the same db. I'm not sure why you would need to do this nor how you could accomplish this unless you wrote your own replication code.

As far as replicating to different schemas in different db's, the usual workaround is to replicate to the same schema and then use synonyms.

HTH,

• Anita
  • "Henrik Ekenberg <henrik.ekenberg_at_anoto.com>" <henrik.ekenberg_at_anoto.com> wrote:
    > Hello,
    >
    > We are running 8.1.7 on Solaris 8 on E4500.
    > We need to replicate one table from one schema to 3
    > other schema and the
    > replicate these 3 schemas to other sites.
    > We can't use snapshot on snapshots because Oracle
    > will do a complete
    > refresh each time.
    > Is there any trick to replicate to different schema
    > with master/master.
    >
    > If you have any advice please let me know.
    >
    > Thanks
    > H. Ekenberg
    >
    >
    >
    

    ---

    
    > Experience is a hard teacher because she gives the
    > test first,
    > the lesson afterward.
    >
    > -- Vernon Law
    >
    > H.Ekenberg
    > Anoto AB
    > E-mail :henrik.ekenberg_at_anoto.com Tel
    > +46 (0)8 410 78 500
    >
    >
    >
    > --
    > Please see the official ORACLE-L FAQ:
    > http://www.orafaq.com
    > --
    > Author: Henrik Ekenber
    > INET: henrik.ekenberg_at_anoto.com>"
    > <henrik.ekenberg_at_anoto.com
    >
    > Fat City Network Services -- (858) 538-5051 FAX:
    > (858) 538-5051
    > San Diego, California -- Public Internet
    > access / Mailing Lists
    >
    

    ---

    
    > To REMOVE yourself from this mailing list, send an
    > E-Mail message
    > to: ListGuru_at_fatcity.com (note EXACT spelling of
    > 'ListGuru') and in
    > the message BODY, include a line containing: UNSUB
    > ORACLE-L
    > (or the name of mailing list you want to be removed
    > from). You may
    > also send the HELP command for other information
    > (like subscribing).
    

    ---

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: abardeen1_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sun Aug 05 2001 - 10:45:46 CDT