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
Solved! Go to Solution.
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
arcpy has 3 functions for dealing with geodatabases and sde
AcceptConnections, DisconnectUser and ListUsers
for example... DisconnectUser—ArcPy Functions | ArcGIS Desktop
I suspect that making changes to a table while someone is connected would lead to unexpected consequences.
Are you using anything to check for connections to the data prior to attempting to modify the table?
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