Unlocking a database object
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Unlocking a database object

  1. #1
    Join Date
    May 2006
    Posts
    17

    Unlocking a database object

    Hi Everyone,

    Could anyone please tell me that is there any mechanism to unlock a database object that is permanently locked without killing the session in which it is locked.

  2. #2
    Join Date
    Mar 2006
    Posts
    40
    The transaction in the locking session should commit or rollback
    go to the oracle clinic
    Quick and easy Oracle database support and consulting

  3. #3
    Join Date
    May 2006
    Posts
    17
    But if the transaction has already locked the object then can we unlock it without killing the session????

  4. #4
    Join Date
    Mar 2006
    Posts
    40
    no it cannot be unlocked like that without killing the session. Doing such thing would comprimise data consistency and as such os not allowed.
    go to the oracle clinic
    Quick and easy Oracle database support and consulting

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width