title: How to delete a user in Oracle 10 including all it's tablespace and datafiles
body: <p>When I give the command to drop a user i.e. DROP USER 'username' cascade,</p>
  
  <ol>
  <li><p>Does it deletes all the tablespace and datafiles used by that particular user.</p></li>
  <li><p>If not, what is the command to delete all the tablespace / datafiles / disk space that   were used by that particular user.</p></li>
  </ol>