title: not able to drop a user in oracle
body: <p>I am trying to drop a tablespace in oracle 10g , using my application .</p>
  
  <p>A bit about my application -- In my application I can create tablespaces.</p>
  
  <p>Now what happens in oracle is that when you create a tablespace , then a new user automatically gets created and is attached to the database.</p>
  
  <p>When you have to drop a tablespace what one has to do is to , first drop the user connected to the database and then the database.  </p>
  
  <p>When I try to drop a user associated with a tablespace.
  An exception is thrown by the database which is the System.Data.OracleClient.OracleException</p>
  
  <p>The details of the exception are as follows - ORA - 01904 (Can Not drop a user that is currently connected)</p>
  
  <p>The thing is I have closed all the connections.Pretty sure about this.</p>
  
  <p>Still oracle is throwing this exception.</p>
  
  <p>Any suggestions???</p>
  
  <p>Still it is not able to drop the user and throws the exception.</p>