Frequently asked question

Can the Oracle parallel option be specified when creating a spatial index on non-partitioned tables?

Last Published: April 25, 2020

Answer

The parallel option should not be specified when creating a spatial index when the underlying table is not partitioned.

If a local index on a non-partitioned table is created, the following error displays:

"ORA-14016: underlying table of a LOCAL partitioned index must be partitioned".

Article ID:000010807

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic