English

Bug: Underlying DBMS error[ORA-02264:

Description

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:

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

Cause

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.

Workaround

If encountering this error, contact ESRI Technical Support for additional information and steps to rectify the problem.