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 laterInformation 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 |