Question: I want to drop some users in Oracle DB using sqlplus but I am getting error:

```
SQL> DROP USER test CASCADE;
DROP USER test CASCADE
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

```

I followed the link in SO to find out the sessions - [Dropping a connected user from an Oracle 10g database schema](https://stackoverflow.com/questions/85804/dropping-a-connected-user-from-an-oracle-10g-database-schema)

But when I ran the command I am not getting any results:

```
SQL> select sid,serial# from v$session where username = 'test';

no rows selected

```

Please help me how to drop users in this case.

Answer: 
Solution : 

login as sysdaba:

```
sqlplus  / as sysdba

```

then:

```
sql>Shutdown immediate;

sql>startup restrict;

sql>drop user TEST cascade;

```

If you want to re-activate DB normally either reset the server or :

```
sql>Shutdown immediate;

sql>startup;

```

:)
I had the same problem, Oracle config in default affects letter register. In exact my Scheme\_Name was written all Capital letters. You can see your Scheme\_Name on "Other Users" tab, if you are using Oracle S