My Oracle Support Banner

Creating a Spatial Index fails with ORA-29833: indextype does not exist (Doc ID 2559108.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

Creating an index with the following type of DDL fails:

CREATE INDEX <index name> ON <table>(<column>)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS ('<parameter string>') PARALLEL ;

SQL Error: ORA-29833: indextype does not exist
29833. 00000 - "indextype does not exist"
*Cause: There is no indextype by the specified name.
*Action: Use public views for the indextypes to see if an
  indextype by the specified name has been cre

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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