Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: trying to setup updateable snapshots
Thanks for you advice.
I'll skip on index replication for now.
The Advanced Replication setup was 'overwhelming' enough to setup 2way replication of just 2 tables. Now I'll have to read the docs to understand why I needed 3 additional oracle users and a dozen oracle jobs.
Thanks again.
-A
On 11 Feb 2005 14:14:26 -0800, "Anurag Varma" <avoracle_at_gmail.com> wrote:
>
>afaik:
>You do not *have* to replicate indexes. However, if you do then
>you can in future issue a index ddl from just the master site and
>ddl will be replicated to other masters (i.e. you would use the
>replication API to issue ddl .. dbms_repcat.execute_ddl).
>Kind of helps in making sure the index is exactly same in
>both master sites.
>
>Anurag
>
.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes
remove NSPAM to email
Received on Mon Feb 14 2005 - 14:32:32 CST