Underlying DBMS error. ORA-00001 Unique Constraint Violated

Last Published: May 4, 2021

Error Message

This article pertains to ArcGIS versions 8.x and 9.x only. Later versions of ArcGIS may contain different functionality, as well as different names and locations for menus, commands and geoprocessing tools.
ArcSDE software, including the application server, command tools, and SDK with C and Java APIs, was deprecated at ArcGIS 10.2.2 and is no longer distributed.

When attempting to load a feature class into ArcSDE using ArcCatalog, the following error appears:

Underlying DBMS error. ORA-00001 Unique Constraint Violated


Deleting an ArcSDE layer with the sdetable administrator command may leave detached entries in some ArcObjects-maintained metadata tables.

For example, a feature class of the same name previously loaded into ArcSDE using ArcCatalog, but deleted with the ArcSDE commands 'sdelayer -o delete' and 'sdetable -o delete' will produce this error.

Solution or Workaround

Clean up the detached entries in the metadata tables and reload the data.

  1. Use the shp2sde command to load a shapefile with the same name as the one previously deleted.
  2. Use ArcCatalog to delete this feature class.
  3. Use ArcCatalog to reload the data.

Article ID:000006235

  • ArcMap 9 x
  • ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic