Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Oracle Tuning pack index rebuild - force no "online" option
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> </DIV>
<DIV>Doc ID: Note:125149.1 <BR>Subject: ALERT: ONLINE Index Rebuild or IOT Table
Move can Produce Corrupt Index </DIV>
<DIV> </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> </DIV>
<DIV> </DIV>
<DIV>Anybody know a way to "fix" the generated code to not use this
option.<BR></DIV>
<DIV> </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