Bug
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.
| Bug ID Number | BUG-000116168 |
|---|---|
| Submitted | August 16, 2018 |
| Last Modified | June 5, 2024 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 10.4.1 |
| Status | Will Not Be Addressed |
Additional Information
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.Workaround
- 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.
Steps to Reproduce
Bug ID: BUG-000116168
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App