Unable to rebuild index online
71610Jul 31 2007 — edited Aug 1 2007CREATE TABLE TRAVEL.TESTIND
(
NAME NUMBER(10),
NO CHAR(8 BYTE),
DATEX DATE
);
CREATE INDEX TRAVEL.PK_TESTIND ON TRAVEL.TESTIND(NAME, NO);
ALTER TABLE TRAVEL.TESTIND ADD (
CONSTRAINT PK_TESTIND
PRIMARY KEY
(NAME, NO)
DEFERRABLE INITIALLY IMMEDIATE );
SQL> alter index PK_TESTIND rebuild online;
alter index PK_TESTIND rebuild online
*
ERROR at line 1:
ORA-08108: may not build or rebuild this type of index online
Any ideas how to rebuild this ndex?
Thanks
S~