My Oracle Support Banner

Spatial Index Creation on an Index Organized Table Fails with ORA-13199 (Doc ID 2093428.1)

Last updated on NOVEMBER 25, 2019

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.