I generate feature layers from subsets of data stored in an Oracle database. After some adjustments to the data, such as deleting columns, adding columns and calculating their values I am writing the feature classes into a file geodatabase.
Looking at the column names generated by ArcGIS Pro I am puzzled that auto-generated columns e.g. GEOMETRY_Length have mixed names. Worst, I cannot alter the field name since the field is required...
I am not sure that this is possible. I know that the RDBMS's handle this differently.
I know the guidelines, and hence I find it irritating, to say the least, that Esri database formats allow such things. In our case the geodatabase serves as an exchange format and has to fulfil some naming conventions with respect to the column names before the data are written in to an RDBMS.
Guess I will have a look into Ideas and add it there if not yet existing.
Not as long as we are within the environment of ArcGIS Pro. It gives us some trouble since we cannot control it with respect to the demands coming from the site of the RDBMS. The latter one is not ours and we have to live up to the column naming definition, so the data import can proceed in a standardized way.
The names you see in Oracle are most likely and Alias. The names that are coming out of the database are the actual names of the column in the Oracle database.
If you want to change the way the column names look you will need to create and alias. or generate the table the way you want it as a template and load the data to that table.
To make a permanent change you would need to go into the Oracle database and change the actual names.
I WOULD NOT RECOMMEND DOING THAT