44. Database Delete User, "Unable to delete the currently connected user"

(1) View the user's connection status

Select username,sid,serial# from V$session

------------------------------------------

The following results:



Username Sid serial#

----------------------------------------

Netbnew 513 22974
Netbnew 514 18183
Netbnew 516 21573
Netbnew 531 9
WUZHQ 532 4562

(2) Find the SID to delete the user, and serial, and remove

-------------------------------------------

Such as: you want to delete the user ' WUZHQ ', you can do this:



Alter system kill session ' 532,4562 '

44. Database Delete User, "Unable to delete the currently connected user"