ERROR

ORA-00920 invalid relational operator

Last Published: April 25, 2020

Error Message

When ArcCatalog is used to register a feature class as versioned, the following error code is returned:

"ORA-00920 invalid relational operator"

Cause

The Oracle parameter STAR_TRANSFORMATION_ENABLED is set to TRUE.

The Oracle parameter is set to TRUE by default when installing an Oracle database using the Data Warehouse template.

Solution or Workaround

Set the Oracle parameter STAR_TRANSFORMATION_ENABLED to false.

Note:
Refer to Oracle documentation on how to set parameters for the database.

    Article ID:000006469

    Software:
    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Related Information

    Discover more on this topic