Re: Oracle multi-master replicaiton: index generation necessary?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Mon, 26 Aug 2002 17:25:36 +1000
Message-ID: <3tka9.15283$g9.48096@newsfeeds.bigpond.com>

Hi Jay,

Peter Sharman, where are you ....

Bugger, he's not around and he knows more about this stuff in his (not so) little finger ...

I don't believe you *must* replicate indexes (although you have the option to specify which indexes you might wish to add to a replication group). The exception to this is the PK which all replicated tables must have else Oracle will turn on you angrily.

Could always give a go and see if it chucks a wobbly.

Cheers

Richard
"jay dee" <jaydee350_at_yahoo.com> wrote in message news:3c179fbf.0208231313.44d39e0c_at_posting.google.com...
> I've seen contradictory documentation on the need to replicate indexes
> when using MM replication. Assuming that the schema is pre-built and
> pre-loaded at all nodes, am I correct in assuming that there is no
> need to CREATE_MASTER_REPOBJECT and generate replication support for
> indexes?
>
> Thx
>
> - jd
Received on Mon Aug 26 2002 - 02:25:36 CDT