Frequently asked question

Can an St_Geometry attribute be dropped using SQL in Oracle?

Last Published: April 25, 2020

Answer

An St_Geometry attribute can be dropped from a table in Oracle if the spatial index has been dropped first. If the spatial index has not been removed, the following Oracle error displays:

"ORA-29884: domain index is defined on the column to be dropped".

Cause: An ALTER TABLE DROP COLUMN was issued on a column on which a domain index exists.

Action: Drop the domain index before dropping the column.

Code:
SQL> ALTER TABLE rivers DROP (shape);
alter table rivers drop (shape)
*
ERROR at line 1:
ORA-29884: domain index is defined on the column to be dropped


For additional information, see the link to the Oracle Documentation in Related Information.

Article ID:000009721

Software:
  • 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

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options