unable to drop the user
Hi All,
I want to drop one user but it gives me error that its connected.
SQL> drop user test cascade;
drop user test cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
when I check through v$seesion for that particualr user it shows me "no rows selecteD"
SQL> select sid,serial#,osuser,machine from v$session where username='TEST;
no rows selected
when I check the what are the segments available of the test users's tablespace,
select count(0) FROM DBA_SEGMENTS where lower(tablespace_name) = 'test_tbs'
COUNT(0)
----------
302
I already bounce the database and try to drop but after bounce the database when run the drop user command it will not prompt after 20 mins, seems like hang.
If anybody ever face this situation then let me know.
Thanks...