ORA-01940: Cannot drop a user that is currently connected. Posted by MOHAMMED ABDUL HAMEED on 11:43 AM

Step 1.Find the Connected Session , user specific

SQL>Select 'alter system kill session ''' || sid || ',' || serial# || ''' IMMEDIATE ;' from v$session where username = 'your_user_name';

Step 2 : Then Kill the Sessions.
    
SQL>Alter system kill session '86,2' IMMEDIATE;

Step 3: Drop user

SQL>Drop user your_user_name cascade;