IOT tables do not support XMLINDEX (Doc ID 2088265.1)

Last updated on DECEMBER 11, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Goal

 Attempting to create an XMLINDEX on a partitioned IOT table will give the following error message

 CREATE INDEX ENTRY_CONTENT ON ITEM_CONTENT (ENTRY_CONTENT) INDEXTYPE IS XDB.XMLINDEX  PARAMETERS ('PATHS (INCLUDE (/entry/n25402))') parallel 8;

*
ERROR at line 1:
ORA-29958: fatal error occurred in the execution of ODCIINDEXCREATE routine
ORA-30978: The XML Index is not locally partitioned.

Attempting to create an XMLINDEX on a non-partitioned IOT table gives the following error message

ERROR at line 1:
ORA-29958: fatal error occurred in the execution of ODCIINDEXCREATE routine
ORA-30989: XML Index on an Index Organized Table is not yet supported

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms