From sorr@rightnow.com Thu, 15 Nov 2001 15:33:57 -0800 From: "Orr, Steve" Date: Thu, 15 Nov 2001 15:33:57 -0800 Subject: RE: Online index rebuilds Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Online index rebuilds Merci beaucoups mon ami. -----Original Message-----From: Jacques Kilchoer [mailto:Jacques.Kilchoer@quest.com]Sent: Thursday, November 15, 2001 3:46 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Online index rebuilds > -----Original Message----- > From: Orr, Steve [mailto:sorr@rightnow.com] > > No Answers? Is the question hard or do you just not like me > anymore? :-) > > Could someone just try the below 2 commands and let me know > if they work on > your system(s)? > > 1) alter index rebuild online compute statistics; > 2) alter index rebuild online compress; Windows 2000 Server LQS> select * from v$version ; BANNER ---------------------------------------------------------------- Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production PL/SQL Release 8.1.7.1.0 - Production CORE    8.1.7.0.0       Production TNS for 32-bit Windows: Version 8.1.7.1.0 - Production NLSRTL Version 3.4.1.0.0 - Production LQS> create table t (n number) ; Table créée. LQS> create index i on t (n) ; Index créé. LQS> alter index i rebuild online compute statistics ; alter index i rebuild online compute statistics * ERREUR à la ligne 1 : ORA-08108: impossible de créer ou de recréer ce type d'index en ligne LQS> alter index i rebuild online compress ; alter index i rebuild online compress * ERREUR à la ligne 1 : ORA-08108: impossible de créer ou de recréer ce type d'index en ligne