title: drop user ORA-00604 and ORA-00054
body: <p>I execute a impdp, but it does not finish because there isnt space in tablespace.</p>
  
  <p>I stop the impdb and now i Need drop the new schema and I use this command:</p>
  
  <pre><code>SQL&gt; drop user TEST cascade;
  drop user TGK_EXOR_IFIL_008_432 cascade
  *
  ERROR at line 1:
  ORA-00604: error occurred at recursive SQL level 1
  ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
  </code></pre>
  
  <p>I dont find any lock on database for this schema:</p>
  
  <pre><code>SQL&gt; select * from v$session where username = 'TEST';
  
  no rows selected
  </code></pre>
  
  <p>I use oracle 11g</p>