English

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

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."

Related Information