English

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

Question

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

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".

Related Information