RE: Online index rebuilds

[Orr, Steve]

Title: RE: Online index rebuilds

Merci beaucoups mon ami.

-----Original Message-----
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 15, 2001 3:46 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Online index rebuilds

> -----Original Message-----
> From: Orr, Steve [mailto:[EMAIL PROTECTED]]
>
> 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