Frequently asked question
Does ArcSDE support ObjectID field as 64-bit integers in Oracle?
Answer
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
Software:
- Legacy Products
Get help from ArcGIS experts
Download the Esri Support App
Related Information
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback