Tuesday, April 10, 2007

How to Release Lock on Table

Here is the query how to release the Lock on the table when we find there is a lock on the particular table..

ALTER TABLE ENABLE/DISABLE TABLE LOCK

3 comments:

  1. how to find if a table has a lock or not.......or whether a table is locked by another transaction

    ReplyDelete
  2. Hi Arun,

    I have added a new topic that can help you out to find lock on object.

    Thanks,
    Bhavik

    ReplyDelete
  3. Hi Arun,

    I have added a new topic that can help you out to find lock on object.

    Thanks,
    ingress

    ReplyDelete