Adding columns by SQL to a feature Class producing ORA-00904 ...

JamesFox1 — Mon, 19 Sep 2011 17:45:32 GMT

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.

Underlying DBMS Error [ORA-00904: "A"."{column name}"; invalid identifier] ...

When I look up the error it seems that the column name may be invalid:
http://www.dba-oracle.com/t_ora_00904_string_invalid_identifier.htm

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.

Any clues?

Oracle: 10.2
ArcGIS: 9.2 (via ArcDesktop 10.0)

-Jim

Re: Adding columns by SQL to a feature Class producing ORA-00904 ...

VinceAngelo — Mon, 19 Sep 2011 18:00:32 GMT

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

topic Adding columns by SQL to a feature Class producing ORA-00904 ... in Data Management Questions

Adding columns by SQL to a feature Class producing ORA-00904 ...

Re: Adding columns by SQL to a feature Class producing ORA-00904 ...