Frequently asked question

Why can I only have 18 characters in my Oracle Spatial spatial index names?

Last Published: April 25, 2020


This is a limitation in Oracle Spatial 8i. The length was increased to 32 characters at Oracle 9.0.1. See the Oracle Spatial 9i User Guide and Reference (Preface: New features).

Oracle 9i is not supported with ArcSDE 8.1 Service Pack 2 and earlier.

If you are going to register your table as versioned with the geodatabase, you must limit the spatial index name to two characters shorter than the maximum length (16 or 30). When ArcSDE versions a business table, it creates an ADDs table. If the business table has an Oracle Spatial spatial index, a spatial index is created for the ADDS table as well. The name of this new index is the the name of the existing index with the _A characters appended to it.

Article ID:000004357

  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options