Underlying DBMS error[ORA-02264:

Last Published: April 25, 2020


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>]

This error may be encountered in ArcCatalog after deleting the spatial index on the feature class and defining a new grid size.


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.

    Article ID:000010341

    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic