Spatial Index Creation on an Index Organized Table Fails with ORA-13199

(Doc ID 2093428.1)

Last updated on DECEMBER 16, 2017

Applies to:

Oracle Spatial and Graph - Version and later
Information in this document applies to any platform.


Attempting to create a spatial index on an index organized table fails in with errors (where in previous versions no error was raised)

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13199: Invalid table type: index organization not supported
Failing sql is:
CREATE INDEX "<schema>"."<index name>" ON "<table owner>"."<table name>" ("<geometry column>") INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" PARALLEL 1

Where <table name> is created as an index organized table.


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