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 -> Index rebuild

Index rebuild

From: Rick Klainer <rklainer_at_neo.lrun.com>
Date: 1998/02/17
Message-ID: <6cdbf6$n60$1@akron5.neo.lrun.com>#1/1

I'm on oracle 7.3.3 on a AIX 4.2.1 Unix server. I find myself having to do index rebuilds to keep performance at an exceptable level. My question is; If I'm doing a rebuild and I have online activity going on will the online activity fail with an oracle message or will it just quene until the rebuild is done. (here I'm assuming the online activity is trying to update the index) My understandings is that you can still read while the index rebuild is going on. Please email with your response. thanks. EMAIL rklainer_at_neo.lrun.com Received on Tue Feb 17 1998 - 00:00:00 CST

Original text of this message

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