How to unlock the locked ArcSDE data

How to unlock the locked ArcSDE data

When the SDE data is locked, the lock request conflicts with an established lock will be reported when you edit or create the featureclass or the registration version. In most cases, disabling the database connection can solve this problem, but sometimes the problem still exists.

How to unlock the locked ArcSDE data

When the SDE data is locked, the lock request conflicts with an established lock will be reported when you edit or create the featureclass or the registration version. In most cases, disabling the database connection can solve this problem, but sometimes the problem still exists.

The solution is:

1. Close all ArcMap and arccatalog sessions.

2. Run the command 'sdemon-o kill-t all-P sde'

3. Run the command 'sdemon-O Info-I locks' then it says 'No ArcSDE to report 'no ArcSDE Layer/State/tabel/ojbects locks registered.

If the data is still locked after the preceding steps are executed, query the lock table in sqlplus:

SQL> select * From SDE. state_locks;

SQL> select * From SDE. object_locks;

SQL> select * From SDE. layer_locks;

SQL> select * From SDE. table_locks;

If records are returned, manually delete the records in these tables.