I am adding columns to a Feature Class DBMS table using an Oracle client. After commiting the change in Oracle (and verifying it was correct)
I get the following error when I open the feature class in Arc Desktop:
Could not load data from the data source. If you cannot correct the problem, press the refresh button to reload the data. Possible problems can include bad network connection, invalid field field, etc.
However it is not. I am getting this with any column I add in SQL. This makes no sense but I suspect something funky may be going on the SDE metadata to kick this off.
This is not the case when adding the column manually in ArcCatalog to the FC fields in the peroperty tab but I have a lot of these these columns to add and would like to automate this.
I am sure that there are scripts and methods in Python to do this but being an Oracle DBA I would do this quicker in an SQL script.
The safest way to add columns to a versioned table is to reconcile and post all your updates, unversion, make the table changes, and re-register the table as versioned. You can't just alter the table, since the ADDs table will not have the parallel columns added. - V
