Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: rebuild primary key indexes on multimaster replication

Re: rebuild primary key indexes on multimaster replication

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 10 Nov 2003 12:51:07 -0800
Message-ID: <1068497488.96766@yasure>


rpr wrote:

>Hi,
> Is there any issue if I rebuild primary keys when I have multi
>master replication running based on those primary keys. Do I have to
>queisce. The reason to rebuild is to save reclaim space, improve
>performance (maybe) and move some of them to another tablespace.
>Thank You.
>
>

Can't answer that ... perhaps others can. The question I want to ask is on what basis
you have decided ot rebuild an index? An activity that is almost never useful.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon Nov 10 2003 - 14:51:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US