Not able to drop the user.
SQL> drop user kana000 cascade;
drop user kana000 cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
SQL> select vs.sid, vs.username, vs.osuser, vs.process fg_pid,
vp.spid bg_pid
from v$session vs, v$process vp
where vs.paddr = vp.addr
/ 2 3 4 5
SID USERNAM OSUSER FG_PID BG_PID
---------- ------- ------------------------------ ------------ ------------
85 oracle 4952 4952
170 oracle 4870 4870
84 oracle 4976 4976
169 oracle 4890 4890
82 oracle 5087 5087
168 oracle 4912 4912
80 oracle 5398 5398
167 oracle 4932 4932
78 oracle 5439 5439
166 oracle 5013 5013
76 oracle 5604 5604
164 oracle 5046 5046
74 oracle 5718 5718
162 oracle 5129 5129
72 oracle 5758 5758
160 oracle 5175 5175
70 oracle 5797 5797
158 oracle 5219 5219
68 oracle 5870 5870
156 oracle 5274 5274
66 oracle 5920 5920
154 oracle 5314 5314
64 oracle 6123 6123
152 oracle 5355 5355
62 oracle 6160 6160
150 oracle 5479 5479
60 oracle 6259 6259
148 oracle 5516 5516
59 oracle 6375 6375
146 oracle 5559 5559
58 oracle 6430 6430
144 oracle 5652 5652
57 oracle 6488 6488
142 oracle 5686 5686
56 oracle 6522 6522
140 oracle 5834 5834
55 oracle 6549 6549
138 oracle 5949 5949
54 oracle 6570 6570
136 oracle 5982 5982
53 oracle 6591 6591
134 oracle 6018 6018
52 oracle 6629 6629
132 oracle 6053 6053
51 oracle 6661 6661
130 oracle 6085 6085
50 oracle 6683 6683
128 oracle 6192 6192
49 oracle 6771 6771
126 oracle 6229 6229
31 SYS oracle 9700 9832
125 oracle 6285 6285
46 oracle 6844 6844
124 oracle 6308 6308
42 DBSNMP oracle 9846 9897
123 oracle 6332 6332
37 DBSNMP oracle 9846 9909
122 oracle 6352 6352
33 oracle 10066 10066
121 oracle 6396 6396
41 oracle 7176 7176
120 oracle 6415 6415
44 oracle 7418 7418
119 oracle 6446 6446
29 SYS oracle 18369 18567
118 oracle 6464 6464
38 SYS oracle 18369 18569
117 oracle 6506 6506
30 DBSNMP oracle 9846 22998
116 oracle 6537 6537
34 oracle 7794 7794
115 oracle 6613 6613
32 SYS oracle 16483 11099
114 oracle 6645 6645
26 SYS oracle 2817 2938
35 SYS oracle 309 907
28 SYS oracle 20473 20513
113 oracle 6891 6891
112 DBSNMP oracle 9846 11283
104 SYS oracle 4270 4363
111 SYS oracle 4270 4365
100 SYS oracle 26316 16505
101 SYS oracle 9700 9829
107 SYS oracle 2817 2940
108 oracle 7797 7797
109 SYS oracle 18369 24249
103 SYS oracle 3083 9676
106 SYS oracle 6839 12404
97 SYS oracle 18367 18368
94 oracle 6830 6830
93 SYS oracle 309 905
95 SYS oracle 8907 2436
92 SYS oracle 28886 21419
98 SYS oracle 23024 28290
91 SYS oracle 14370 4757
99 SYS oracle 21477 27372
96 rows selected.
But no one connected ?. Then how to drop it....