topic Re: add field in Data Management Questions

add field

jayasudha — Mon, 22 Aug 2016 09:20:06 GMT

I have created a feature class using ArcGIS.
I want to add some columns using Oracle SQL alter table statement.
This works fine for me.
I want to know whether it is acceptable practice ?

Re: add field

NeilAyres — Mon, 22 Aug 2016 09:24:18 GMT

As long as your ALTER doesn't affect any of the ArcGIS fc required fields it will be fine

Re: add field

Anonymous User — Mon, 22 Aug 2016 11:42:22 GMT

Hello,

Its works and acceptable in ArcGIS/GIS software.

But when you trying to create new use same process.

Thanks.

Re: add field

JoshuaBixby — Mon, 22 Aug 2016 12:32:05 GMT

I get a sense you are new to ArcGIS, or at least new to working with Esri enterprise geodatabases. There are lots of risks using SQL to directly manipulate database objects in enterprise geodatabases. I don't mean edit the data in the objects, which can be risky in certain situations too, but changing the structure of the objects. For example, is the data versioned? If so, editing the base table using an SQL statement will cause a disconnect between the base table, add & delete tables, and any versioned views that have already been created. If the data isn't versioned, it reduces the risk, but there are still changes that can be made using SQL that will break some part of the geodatabase.

SQL and enterprise geodatabases

Re: add field

jayasudha — Tue, 23 Aug 2016 04:17:11 GMT

Thanks to all