I have written a script that imports cad drawings into a geodatabase. I first was importing into a file gdb and have since modified it to use SDE with Oracle as a db. Troubleshooting has a been a nightmare. The overall error is:
ERROR 999999: Error executing function.
Underlying DBMS error [ORA-00911: invalid character
(SDE.VU_0029_04_dwg_Point)] [SDE.VU_0029_04_dwg_Point]
Failed to execute (Merge).
But, after testing the tablename throughly I came to the conclusion the problem lies within the column names. So, I added code to check those and this is the result:
Fieldname EntLinetype changed to EntLinetyp
Fieldname BlkLinetype changed to BlkLinetyp
Fieldname APPLICATION changed to APPLICATIO
Fieldname FILE_VERSION changed to FILE_VERSI
Fieldname INTERNAL_UNITS changed to INTERNAL_U
Fieldname FACILITY_ID changed to FACILITY_I
Fieldname LEGEND_POINT_X changed to LEGEND_POI
Fieldname LEGEND_POINT_Y changed to LEGEND_POI
Now my real question is why is arcpy truncating my column names to 10 characters when my db supports 30 characters? Is there a way I can get around this?