laptop and a wrench

Bogue

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.

Dernière publication: November 9, 2018 ArcSDE/Enterprise Geodatabase
Numéro d’ID de bogue BUG-000116168
EnvoiAugust 16, 2018
Dernière modificationJune 5, 2024
S’applique àArcSDE/Enterprise Geodatabase
Version trouvée10.4.1
StatutWill Not Be Addressed

Informations supplémentaires

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.

Solution de contournement

  1. In ArcCatalog, right-click the table using float.
  2. Export > To Geodatabase.
  3. Fill in the Output Location and Output Table name.
  4. In the Field Map, right-click the field using the float data type (in the sample script that is "floatfield").
  5. Click Properties.
  6. Change scale to 8.
  7. Click OK and execute the export. The table in the enterprise geodatabase retains decimals now.

Étapes pour reproduire

ID de bogue: BUG-000116168

Logiciel:

  • ArcSDE/Enterprise Geodatabase

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement