-
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.
-
The transaction in the locking session should commit or rollback
-
But if the transaction has already locked the object then can we unlock it without killing the session????
-
no it cannot be unlocked like that without killing the session. Doing such thing would comprimise data consistency and as such os not allowed.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|