Unlocking a database object

[jaingaurav]

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.

[oracli]

The transaction in the locking session should commit or rollback

[jaingaurav]

But if the transaction has already locked the object then can we unlock it without killing the session????

[oracli]

no it cannot be unlocked like that without killing the session. Doing such thing would comprimise data consistency and as such os not allowed.