Is This Content Helpful?
We're glad to know this article was helpful.
When moving a versioned feature class with archiving enabled and the feature classes geometry stored as SDEBINARY, between load_only mode and normal_io mode, it fails with the following error:
Underlying DBMS error[ORA-02264:
name already used by an existing constraint (A<#>_FK1)][<owner>.<feature_class>]
The error is only encountered when the data is stored as an SDEBINARY feature class and archiving is enabled. The problem is when the archive class is being brought out of load_only mode; it attempts to use the base feature classes layer_id in the name of the A<#>_FK1 constraint. The creation of the constraint fails because the constraint was created (and disabled) when the base feature class was first brought out of load_only mode.
If encountering this error, contact ESRI Technical Support for additional information and steps to rectify the problem.