Frequently asked question

Are Oracle function-based indexes supported with versioned tables?

Last Published: April 25, 2020

Answer

Oracle function-based indexes cannot exist on a table when the object is being registered as versioned.

If a table that has an Oracle function-based index is registered as versioned, the following error is encountered:

"Failed to register as versioned. Attribute column not found [ORA-00904: "SYS_NC00019$": invalid identifier (A158)][TOMB.STATES]"

When a table is registered as versioned, ArcGIS detects what indexes are present on the table to create the indexes on the same attributes when the versioned adds table is created.

Once the table has been registered as versioned, the Oracle function-based index can then be created on the versioned table and the table's adds table attribute.

Article ID:000010749

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