Changing the field REC_ID in the database table from type NUMBER to VARCHAR2(10) seems to have solved the problem, but in an odd way, since integers saved as varchar do not sort by the integer value. Order by rec_id saved varchar returns like this
1000000
2
The end result is what I wanted, a table created in arcgis filled with data copied from the table in the database. So what drove the requirement to set a unique_ID field, that has to be a string instead of a number, instead identifying that unique id itself or creating one for it, as it does for csv data added to the arcgis?
The documentation says the unique id can have a data type of integer, but Oracle does not have integer as a data type. You have to save integers and numbers and setup your app to not store numbers with decimal places in your number field reserved for integer-use , or that will bomb.
I remember when arcgis caeme out in 1982. I did not do much with it, but I had friends who were deep into it and I would see their work. Similar experience 2005-2012. It was full of stupid complications like this. Here we are 42 year later, and what I see is a much larger more complicated product that can provide useful work, still full of all kinds of stupid quirks that make working with it a form of torture.