-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|