Frequently asked question

Does ArcSDE support ObjectID field as 64-bit integers in Oracle?

Last Published: April 25, 2020


No, ArcSDE can only support ObjectID as 32-bit integers.

The ObjectID field with Oracle data type NUMBER(38) is mapped as LONG INTEGER data type in a geodatabase as 4 bytes (32-bit number). Please note the following limitations:

• LONG INTEGER data type can only hold 10 digits currently.

• The signed range of integer values that can be stored in 32 bits is -2,147,483,648 through 2,147,483,647 (unsigned: 0 through 4,294,967,295).

• For ArcGIS/ArcSDE, the OBJECTID range is from 1 to 2,147,483,647.

• Any number greater than 2,147,483,647 produces an error message displayed in ArcCatalog or ArcSDE administrative command lines:

"ORA-01455: converting column overflows integer datatype."

Article ID:000010398

  • 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