How to Rebuild a Domain Index?
699346Feb 24 2010 — edited Feb 24 2010Using Oracle 10g RAC +ASM
I've created a table with a domain index (TEXT). Is it possible to rebuild the index without dropping the index then recreating?
Attempts to REBUILD the index results in:
ALTER INDEX IW.IDXCLAIMSBINARY2 REBUILD NOCOMPRESS NOPARALLEL NOLOGGING
Error at line 1
ORA-29871: invalid alter option for a domain index
The table (in part):
CREATE TABLE CLAIM_SOURCE_REF
(
CLAIM_SOURCE_REF_ID CHAR(18 BYTE) NOT NULL,
CLAIM_SOURCE_REF_CODE VARCHAR2(4 BYTE),
CLAIM_SOURCE_REF_PR_DESC VARCHAR2(250 BYTE),
CLAIM_SOURCE_REF_DOC_REF VARCHAR2(250 BYTE),
CLAIM_SOURCE_REF_PATH VARCHAR2(250 BYTE),
CLAIM_SOURCE_REF_STUDY VARCHAR2(100 BYTE),
CLAIM_SOURCE_LAB_REF VARCHAR2(100 BYTE),
CLAIM_PUBLISHER_ID_FK CHAR(18 BYTE),
CLAIM_SOURCE_REF_YEAR VARCHAR2(4 BYTE),
TEXT BLOB,
TEXT_LOADED CHAR(1 BYTE),
FILE_NAME_UNC VARCHAR2(255 BYTE)
)
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
CREATE INDEX IDXCLAIMSBINARY2 ON CLAIM_SOURCE_REF
(TEXT)
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS('lexer pdf_lexer')
NOPARALLEL;