Henrik,
No, in 8.1.7 I don't see an easy way of doing this.
You could accomplish this in 9i with multi-level
updatable snapshots/materialized views as I mentioned,
but the conflict resolution gets rather tricky and
results in a lot more network traffic as the changes
have to be sent back up and down multiple levels.
HTH,
- Anita
- "Henrik Ekenberg <henrik.ekenberg_at_anoto.com>"
<henrik.ekenberg_at_anoto.com> wrote:
> Hello Anita
>
> Thanks for your answer.
> We need to share some tables between different
> software. So we need to
> replicate these tables to different schemas. One of
> these schemas will
> probably be on an other machine.
> Then will we replicate these schemas to different
> sites.
> You can't replicate one snapshot in 8.1.7, so we
> can't use snapshot to
> solve our problem.
>
> Regards
> H. Ekenberg
>
> On Sun, 5 Aug 2001, A. Bardeen wrote:
>
> -!-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: 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 Tue Aug 07 2001 - 08:45:07 CDT
