- This error happens because there is locked session and the solution to kill the session using the following steps :-
- first fin the locked session using this query from db account select sid,serial# from v$session where sid in (select a.SESSION_ID from v$locked_object a, dba_objects b where a.object_id = b.object_id and a.SESSION_ID not in (select a.SESSION_ID from v$locked_object a, dba_objects b where a.object_id = b.object_id and session_id in (select sid from v$lock where block = 1)));
- Then kill the locked session using sid,serial# from the first query using this :- alter system kill session '119,148 ' immediate;
No comments:
Post a Comment