RE: Online index rebuilds

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 15 Nov 2001 15:05:04 -0800
Message-ID: <F001.003C6D96.20011115144530@fatcity.com>

> -----Original Message-----
> From: Orr, Steve [mailto:sorr_at_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 <name> rebuild online compute statistics;
> 2) alter index <name> 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 Received on Thu Nov 15 2001 - 17:05:04 CST