Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie Help - Advanced Replication
When using UPDATABLE snapshots (symmetric replication) you need to define a
Replication Master Group on your MASTER SITE including the tables which are
to be replicated as upd. snapshots. Then on your snapshot site you define a
corresonding Snapshot Group and include the tables to be replicated AS
updatable. Issues to consider are also: Parallel Propagation ON/OFF (on with
multi CPU), placement of DEF$ tables outside SYSTEM tablespace, proper
sizing of snapshot/snapshot indexes/updatable snapshot log etc.
Regards
Lars Bo
COREBIT TPI AG, Switzerland LarsBoV_at_NOSPAMcorebit.dk
Nemniss wrote in message <77hos9$jm6$1_at_hermes.is.co.za>...
>Hi,
>
>Can any1 please help me? I need 2 setup Oracle Advanced Replication
between
>2 Oracle 8.0.4 Servers. I have created the DB link, the users, the
snapshot
>logs and readonly snapshots - this works 100%. Now I need to add updatable
>snapshots. How do I create updatable snapshots, also any information
>regadring updatable snapshots R welcome.
>
>Thanx in advanace
>
>Nemniss
>
>
Received on Wed Jan 13 1999 - 04:33:38 CST