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"


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.

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

    Article ID:000006469

    • Legacy Products

    Receive notifications and find solutions for new or common issues

    Get summarized answers and video solutions from our new AI chatbot.

    Download the Esri Support App

    Related Information

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options