Re: advanced replication

Steve

I assume you're using the replication procedures to transfer the ddl to do this. If so, then all that's transferred is the DDL statement itself, which then executes at the remote site. Since it's almost certain that rowids etc. will be different between the databases, it not only doesn't make sense to transfer the index itself, it also won't work.

Speed should be the same in either case, and the index is kept updated remotely by the index itself, not by transferring the index entry and the table entry via replication.

HTH. Pete

Steve A wrote:

> Hi,
> being a bit of a newbee to oracle, i have the following question.
>
> In the advance replication , I can request replication of indexes to
> remote sites.
>
> 1. Does oracle actually try to transfer the whole index file or just the
> Formula for the index?
>
> 2. is it faster to define the index at the remote site & not try to
> replicate it over a link?
>
> 3. once the index is setup at the remote site ,and a record is added to
> the local site, is just the record transfered, then teh remote index
> takes care of the rest or does the modification to the index get
> transfered as well.
>
> steve

Received on Tue Sep 28 1999 - 12:16:10 CDT