title: ORA-00955: name is already used by an existing object
body: <p>In oracle 11G, I want to drop a user PERMANENTLY, ie no trace of that user should remain and I should not get "existing object" errors like this - ORA-00955: name is already used by an existing object, when I try to recreate that User with its tables.</p>
  
  <p>Please help me to do this.
  Thanks.</p>
  
  <p>EDIT - </p>
  
  <p>Commands to create user with table and columns</p>
  
  <pre><code>CREATE USER Products identified by discounted
  GRANT ALL PRIVILEGES TO Products
  CREATE TABLE Cars(Brand varchar(25),Model varchar(25))
  </code></pre>
  
  <p>The above is followed by,
  Commands to drop user completely and re-create it completely</p>
  
  <pre><code>DROP USER PRODUCTS CASCADE
  CREATE USER Products identified by discounted
  GRANT ALL PRIVILEGES TO Products
  CREATE TABLE Cars(Brand varchar(25),Model varchar(25))
  </code></pre>
  
  <p>Causes the exception-</p>
  
  <pre><code>java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
  </code></pre>