Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a set of feature classes that I want to be able to edit schema or what ever I want to do in the heat of the battle and I don't want to be stiffled by schema locks.

I have a interpretable requirement to have all analysis done in the db. I have them outside of any feature dataset but I guess that there may be schema locks for any client hooked to the geodb.

Is the answer to house this in a feature dataset? Or are there other alternatives?

share|improve this question

Are you or is anyone else on your SDE doing non-versioned or versioned editing? What sort of analysis are you doing and why does it need to be in SDE and not a file or personal geodatabase? Typically geoprocessing-type analyses produce a lot of junk or intermediate tables that you really don't want in your multiuser environment. How frequently will you be doing schema changes and what are the nature of the schema changes? Does your organization already have established procedures as to when and how to perform schema changes?

The point is you can't just "do whatever you want" if there are other users in your database. DBMSes and SDE implement concurrency and locking to ensure the ACID properties are not broken and so that you don't inadvertently blow things up.

Also there is a difference between the types of locks in SDE. This help topic has a good overview. Essentially there are shared locks which are created when someone is viewing or editing an object class, and there are exclusive locks for when someone is attempting to change the schema of an object class themselves. As for feature datasets, locks apply to all the object classes in a feature dataset, so that is more likely to work against you than for you.

You can find out what users have locks to an SDE layer using sdemon or by looking at the SDE_layer_locks SDE system table. Provided you have the necessary permissions you could delete those locks that are preventing you from making your schema changes, at the risk of blowing away someone else's edits or worse. Know the risks and ramifications of modifying system tables before you do so!

Note that in 10.1, they are adding geodatabase administration tools that make viewing and managing user locks/connections easier.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.