changing table structures - LOCK issue

robert_at_work

Hi there,

I need to modify tables (add columns) in Oracle (SDE). When I try do that (through ModelBuilder) I get an error 00464 - LOCK.

Is there any way I can modify a table without needing to kick out all other users including ArcGIS Server?

I cant believe that for such a basic task I need to make sure no one else is using the system. Is that really true?

Rob

George_Thompson

This would be expected behavior as their may be dependencies downstream of the schema change. For example. if the data is versioned, the delta tables would need to be updated at the same time as to not create any issues.

Schema locking - Schema locking—ArcGIS Help | ArcGIS Desktop