How to create partition index for Oracle text tables
CREATE TABLE emp (
empno NUMBER,
ename VARCHAR2(10 BYTE),
job VARCHAR2(20 BYTE),
mgr NUMBER,
hiredate DATE,
sal NUMBER,
comm NUMBER,
deptno NUMBER,
text CLOB
);
ALTER TABLE EMP MODIFY PARTITION BY RANGE (EMPNO) INTERVAL (10)(
PARTITION P1 VALUES LESS THAN (10),
PARTITION P2 VALUES LESS THAN (20),
PARTITION P3 VALUES LESS THAN (30));
CREATE INDEX IDX_TEXT ON EMP(TEXT) INDEXTYPE IS CTXSYS.CONTEXT LOCAL;
Error starting at line : 6 in command -
CREATE INDEX IDX_TEXT ON EMP(TEXT) INDEXTYPE IS CTXSYS.CONTEXT LOCAL
Error report -
ORA-29940: User-managed domain indexes are not allowed on interval-partitioned tables.
29940. 00000 - "User-managed domain indexes are not allowed on interval-partitioned tables."
*Cause: An attempt was made to create a local user-managed domain index on