ArcGIS 10.1 sp1 with Oracle 11g
I've got a versioned feature class that I have discovered has a base table with a different schema than the corresponding A table. (A + registration_id from sde.table_registry)
The only possible explanation I can think of is someone went in and manually added/removed fields from the base table or the A table. I don't BELIEVE this has happened because there aren't many people with access to this database and I would hope they all know better than to do this on a versioned feature class/table...
Are there any other ways that this could happen? The only other item of interest is that this was just upgraded from 9.3.1 to 10.1. I'm in the process of trying to get a 9.3.1 backup used for the upgrade restored to see if that contains this problem...
I was initially alerted to this problem while trying to export data. The export to xml workspace fails completely without any info, but the copy feature class via Ctrl+C in ArcCatalog throws the error:
[ORA-00904: "A"."DUCT_MATERIAL":invalid identifier][GEOSPATIAL.SPAN]
I guess my question should be how did this happen and how do I fix it. I could probably go through and write some sql statements to add these fields, but this may not be the only table with this problem and it would be tedious. Any automated way of doing this?