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

Last updated on DECEMBER 31, 2015

Applies to:

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

Symptoms

Attempting to create a spatial index on an index organized table fails in 12.1.0.2 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.

Cause

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