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 <[EMAIL PROTECTED]>"
<[EMAIL PROTECTED]> 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 :[EMAIL PROTECTED] Tel
> +46 (0)8 410 78 500
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Henrik Ekenber
> INET: [EMAIL PROTECTED]>"
> <[EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
