ERROR
ORA-00920 invalid relational operator
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
Receive notifications and find solutions for new or common issues
Get summarized answers and video solutions from our new AI chatbot.
Related Information
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App