Export from ArcGIS Pro to .csv - Need to include the object_id values

[MillieBuckner]

Is there  a way to include the object_id field when exporting from arcGIS to a .csv file?

[George_Thompson]

Is the data you are exporting part of the geodatabase or just a table in the database?

When you add the table to a map does it ask for you to "assign" an ObjectID (in a pop up window)?

[MillieBuckner]

Is the data you are exporting part of the geodatabase or just a table in the database?

When you add the table to a map does it ask for you to "assign" an ObjectID (in a pop up window)?

Answer:  yes, the map asked for the field(s) that would serve as the unique id.  

[MillieBuckner]

George,

I am putting a series of screenshots together showing the whole sequence the leads to the loss of the id field. I think I can include a solution.  It strikes me as an behavior, so I am wondering if I am creating a problem by making a misstep is how I am working with the product and my data.

[George_Thompson]

Thanks for the info above. I think the issue is that when you add a table not registered with the geodatabase, and you have Pro (ArcGIS) create an ObjectID, it is NOT a field in the table. Pro will create a "virtual" ObjectID field and use that in the client.

Does the source table have an ObjectID field that matches what you see in Pro in Oracle (look using sqlplus)?

If the field does not exist in the Oracle table, then it would not be exported from Pro.

[MillieBuckner]

Problem appears when id field is not available for export.  why?  You have to look at the last image to see it

Table from oracle database being added to map through dbConnection

Data just added to arcgis from an oracle table

Geocoding the addresses

Export geocoding

Picking a folder not in project for saving exported data

[George_Thompson]

Ok, so it looks like you are exporting the "new" geocoded table. When you geocode a table it creates a new feature class (table).

Not sure why those fields are missing.

[MillieBuckner]

There is a different problem upstream from the export of the geo-coded addresses.   arcgis keeps failing when looking at oracle data, because oracle is giving arcgis old data.  Here are the steps

1.  Make table 001

2.  update table 001

3.  add table 001 to arcgis pro.

4.  The data visible in arcgis is the data that was in the table on step 1, not step 2

To get around this, I have to make table 002 from table 001 after it has been updated, and show arcgis table 002.

Something is wrong with our oracle installation.