Dropping a user

Initially I accessed db with user 'ADITYA' and I logged out.

When I tried to drop the user 'ADITYA' from sys schema, it showed the below error

Error starting at line 1 in command:

DROP USER ADITYA

Error report:

SQL Error: ORA-01940: cannot drop a user that is currently connected

01940. 00000 - "cannot drop a user that is currently connected"

*Cause: Attempt was made to drop a user that is currently logged in.

*Action: Make sure user is logged off, then repeat command.

So I verified the view v$session

SELECT *fROM V$SESSION WHERE USERNAME='ADITYA';

It showed the status 'Inactive' in STATUS field but still could not drop the user 'ADITYA' from sys Schema.

Hence I had to kill the session of the user.

-- alter system kill session ','; ALTER SYSTEM KILL SESSION '29, 1';

Then the drop worked from sys user.