Is This Content Helpful?
We're glad to know this article was helpful.
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 orphaned 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.
Clean up the orphaned entries in the metadata tables and reload the data.