beginnerz
04-09-2007, 07:10 AM
Hi all,
i tried to drop a user in my oracle
SQL> drop user sunil;
drop user sunil
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
and i went to session
scott@ORA92> alter system kill session '11,16';
System altered.
but after that when i search for
select username from dba_users where username = 'SUNIL'
the session 11,16 SUNIL it is still there?
am i doing something wrong here?
i tried to drop a user in my oracle
SQL> drop user sunil;
drop user sunil
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
and i went to session
scott@ORA92> alter system kill session '11,16';
System altered.
but after that when i search for
select username from dba_users where username = 'SUNIL'
the session 11,16 SUNIL it is still there?
am i doing something wrong here?