If a table is created in Oracle using the Oracle FLOAT data type instead of the copy and paste function in ArcGIS Desktop, the table drops the decimals if the target location is an enterprise geodatabase or database.
上次发布: November 9, 2018ArcSDE/Enterprise Geodatabase
漏洞 ID 编号
BUG-000116168
已提交
August 16, 2018
上次修改时间
June 5, 2024
适用范围
ArcSDE/Enterprise Geodatabase
找到的版本
10.4.1
状态
Will Not Be Addressed
开发团队已考虑过该问题或请求,并决定不会解决该问题。 问题的“其他信息”部分可能包含进一步说明。
附加信息
ArcGIS does not utilize or support the Oracle Float data type.
(http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/dbms-data-types-supported.htm#ESRI_SECTION1_F4879D2C89A64EAE8767346408E6EDB6)
Consider using NUMBER(p,s) instead of Float.
解决办法
In ArcCatalog, right-click the table using float.
Export > To Geodatabase.
Fill in the Output Location and Output Table name.
In the Field Map, right-click the field using the float data type (in the sample script that is "floatfield").
Click Properties.
Change scale to 8.
Click OK and execute the export. The table in the enterprise geodatabase retains decimals now.