title: Why isn't Oracle DROP USER CASCADE removing all remants of a user from disk?
body: <p>I need to eliminate all remnants of specific users from an Oracle 11g R2 database.  This means not only deleting the users one by one, but also deleting all objects associaated with that user, in addition to all physical remnants on the disk, such as <code>.dbf</code> files.  </p>
  
  <p>I read several articles suggesting syntax for this, and settled on the following series of two lines for each user:  </p>
  
  <pre><code>DROP USER &lt;username&gt; CASCADE;
  DROP TABLESPACE &lt;username&gt; INCLUDING CONTENTS AND DATAFILES;  
  </code></pre>
  
  <p>I then typed <code>SELECT USERNAME, DEFAULT_TABLESPACE FROM DBA_USERS;</code> and confirmed that the USER with the specific username was not included in the results.  </p>
  
  <p>But I also have the folder containing the <code>.DBF</code> files open, and I notice that <strong>the <code>.DBF</code> files are not deleted even though the Oracle SQL Developer interface tells me that both of the two above commands succeeded.</strong>  </p>
  
  <p><strong>What specific syntax or other actions do I need to take in order to delete EVERY remnant of the user and its associated schema, etc. from an Oracle 11g R2 database?</strong>  </p>
  
  <hr>
  
  <p><strong>ONGOING RESEARCH:</strong>  </p>
  
  <hr>
  
  <p>After reading @EliasGarcia's approach, I tried his first command <code>select tablespace_name from dba_data_files where file_name = 'file_including_path'</code> for the same username that was used in the preceding commands in the OP.  But this query did not produce any results because the table space was deleted by the two commands shown above in my OP.   </p>
  
  <p>Given that I have to delete the user and all objects related to the user also, can someone please show how to combine the OP approach with @EliasGarcia's approach?  For example, <strong>the OP is asking for something like <code>DROP USER username CASCADE INCLUDING CONTENTS AND DATAFILES;</code></strong></p>
  
  <p>I hesitate to simply delete the <code>.dbf</code> files after running the above commands.</p>