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.
Printable View
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.