| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: advanced replication
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 developersis 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>
 |
 |