Oracle Text (MOSC)

MOSC Banner

How to create partition index for Oracle text tables

edited Feb 11, 2021 6:17PM in Oracle Text (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center