Re: advanced replication

Steve

All the replication is doing really is replicating the table value. When the remote table is updated to reflect the change that is replicated, the remote index is automatically updated to reflect the change as well. This is done via normal Oracle processing - no difference is caused by the row change being due to replication.

Row id's can easily be different between two different databases. Remember what they reflect - the row #, block # and file #. If a row needs to move to a different block due to an increase in size causing row migration, there may be different blocks on the free list between each database. Hence you can quite easily end up with different row id's for the same row between different databases.

HTH. Pete

Steve A wrote:

> Hi,
> So there is a shedule for purge and the job,
> once the index has been setup at the remote site , what exactly does the
> shedule do?
> since any updates to the table would result in the index automatically
> being updated at each site?
>
> Also you state the row Id would possibly be different, is that coorect?
> since the tables are supposed to be replicated, the only difference
> would be added or deleted records shurly.
>
> steve
>
> Pete Sharman <psharman_at_us.oracle.com> wrote:
>
> > This is a multi-part message in MIME format.
> > --------------05D39363F216FBDB345A7E46
> > Content-Type: text/plain; charset=us-ascii
> > Content-Transfer-Encoding: 7bit
> >
> > 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
> >
> > --------------05D39363F216FBDB345A7E46
> > Content-Type: text/x-vcard; charset=us-ascii;
> > name="psharman.vcf"
> > Content-Transfer-Encoding: 7bit
> > Content-Description: Card for Pete Sharman
> > Content-Disposition: attachment;
> > filename="psharman.vcf"
> >
> > begin:vcard
> > n:Sharman;Peter
> > tel;cell:+1.650.868.9969
> > tel;fax:+1.650.633.1669
> > tel;work:+1.650.607.0109
> > x-mozilla-html:FALSE
> > url:http://eif.us.oracle.com
> > org:Advanced Technology Solutions;Oracle Corporation
> > adr:;;500 Oracle Parkway M/S OPL-A4019;Redwood Shores;California;94065;USA
> > version:2.1
> > email;internet:psharman_at_us.oracle.com
> > title:Managing Principal Consultant
> > note;quoted-printable:=0D=0A=0D=0A **** The statements and opinions expressed
> here are my **** <br>=0D=0A **** own and do not necessarily represent
> those of **** <br>=0D=0A **** Oracle Corporation.
> =20 **** <br>=0D=0A <br>=0D=0A"Controlling application developers
> is like herding cats." <br>=0D=0AKevin Loney, ORACLE DBA Handbook
> <br>=0D=0A=0D=0A"Oh no it's not! It's much harder than that!"
> <br>=0D=0ABruce Pihlamae, long term ORACLE DBA <br>
> > x-mozilla-cpt:;26064
> > fn:Pete Sharman
> > end:vcard
> >
> > --------------05D39363F216FBDB345A7E46--

Received on Wed Sep 29 1999 - 17:47:31 CDT