FAQ: Does ArcSDE support ObjectID field as 64-bit integers in Oracle?
Does ArcSDE support ObjectID field as 64-bit integers in Oracle?
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."