laptop and a wrench


Dragging in an Oracle database view to ArcMap 10.3 converts long integer fields created with default settings to double, and all values are converted to 0.

Last Published: October 4, 2018 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000087604
SubmittedMay 12, 2015
Last ModifiedJanuary 28, 2021
Applies toArcSDE/Enterprise Geodatabase
Version found10.3
Version Fixed1.4


Specify precision of 10 when creating the long integer fields.ORAdd the database view from File menu > Add Data.ORCreate the database view using the CAST function to specify the column precision to NUMBER(10).ORUse a double field instead of long.ORThe Table to Table tool can be used to create a new table that uses a double field. The data type can be changed in the Table to Table's Field Mapping window.

Steps to Reproduce

Bug ID: BUG-000087604


  • ArcSDE/Enterprise Geodatabase

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic