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

Home -> Community -> Mailing Lists -> Oracle-L -> Oracle Tuning pack index rebuild - force no "online" option

Oracle Tuning pack index rebuild - force no "online" option

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Tue, 12 Dec 2000 13:03:49 -0500
Message-Id: <10708.124350@fatcity.com>


This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages.

--=_85DE8489.4A2B418F

Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Metalink is the following article:

Doc ID: Note:125149.1=20
Subject: ALERT: ONLINE Index Rebuild or IOT Table Move can Produce Corrupt = Index=20

It mentions to avoid using the "online" option since if rebuild fails, = will get corrupt index if other dml also accessing the table.

Anybody know a way to "fix" the generated code to not use this option.

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204

--=_85DE8489.4A2B418F
Content-Type: text/plain
Content-Disposition: attachment; filename="TEXT.htm"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.3207.2500" name=GENERATOR></HEAD>
<BODY style="FONT: 10pt Courier New; MARGIN-LEFT: 2px; MARGIN-TOP: 2px">
<DIV>On Metalink is the following article:</DIV>
<DIV>&nbsp;</DIV>
<DIV>Doc ID: Note:125149.1 <BR>Subject: ALERT: ONLINE Index Rebuild or IOT Table
Move can Produce Corrupt&nbsp;Index </DIV>
<DIV>&nbsp;</DIV>
<DIV>It mentions to avoid using the "online" option since if rebuild fails, will
get corrupt index if other dml also accessing the table.</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>Anybody know a way to "fix" the generated code to not use this
option.<BR></DIV>
<DIV>&nbsp;</DIV>
<DIV>Jeffrey Beckstrom<BR>Database Administrator<BR>Greater Cleveland Regional
Transit Authority<BR>1240 W. 6th Street<BR>Cleveland, Ohio 44113<BR>(216) 781-4204</DIV></BODY></HTML> Received on Tue Dec 12 2000 - 12:03:49 CST

Original text of this message

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