Underlying DBMS error. ORA-00001 Unique Constraint Violated

Error Message

Note:
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.

Note:
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:

Error:
Underlying DBMS error. ORA-00001 Unique Constraint Violated

Cause

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.