Hi All,
I got a problem in dropping a user. Let me explain in detail.
I have to drop a user 'TELCO'.
I tried to drop the user by connecting to Sysytem user.
>DROP USER TELCO CASCADE;
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

then i querried in V$SESSION for sid,serial#,status and tried to killl the session.
>ALTER SYSTEM KILL SESSION '16,4558';
ERROR at line 1:
ORA-00031: session marked for kill
This error is because of the process is in UN-INTERRAPTIBLE mode(rollback or network operation...etc)

My Question is, if it is in process why its status in V$SESSION is showing as KILLED?
And How to Drop this user?
Please reply back me ASAP.
thank you ,
esreddy.