hi,
I need to truncate a table ..but that table was locked by a user ..i killed the user but it is not killing .. i'm getting this error .

SQL> truncate table dmn.dmn_plant_material
2 /
truncate table dmn.dmn_plant_material
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified


SQL> alter system kill session '22,20004';
alter system kill session '22,20004'
*
ERROR at line 1:
ORA-00031: session marked for kill

but the status of user is KILLED in v$session


SQL> select sid,serial#,username,osuser,status from v$session where sid = 22;

SID SERIAL# USERNAME OSUSER STATUS
---------- ---------- -------------------- -------------------- --------
22 20004 BO_DI SYSTEM KILLED


I then tried truncating and still the same error

SQL> truncate table dmn.dmn_plant_material
2 /
truncate table dmn.dmn_plant_material
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified .


Plz let me know how to kill this session ..

Thanx
sarav