changing table structures - LOCK issue

464
2
Jump to solution
08-14-2019 01:12 AM
robert_at_work
New Contributor III

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

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
George_Thompson
Esri Frequent Contributor

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 

--- George T.

View solution in original post

2 Replies
DanPatterson_Retired
MVP Emeritus

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?

George_Thompson
Esri Frequent Contributor

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 

--- George T.