title: Oracle Error ORA-19502: write error on file
body: <p>I’m creating a tablespace in oracle using this code: </p>
  
  <pre><code>Create BIGFILE tablespace SPC_X
      Datafile 'SPC_X.dbf'
        size 200M
        AUTOEXTEND ON NEXT 50M 
    ONLINE;
  </code></pre>
  
  <p>Up to now, I have created couple of tablespaces, without any problem. Today I have created 5 tablespaces (500 M) and dropped them all. Right now I am facing this error after execution code, mentioned above:</p>
  
  <pre><code>SQL-Error: ORA-19502: write error on file " SPC_X.dbf", block number 11136 (block size=8192)
  ORA-27072: File I/O error
  Additional information: 4
  Additional information: 11136
  Additional information: 708608
  19502. 00000 -  "write error on file \"%s\", blockno %s (blocksize=%s)"
  *Cause:    write error on output file
  *Action:   check the file
  </code></pre>
  
  <p>Following Information could be helpful: </p>
  
  <ul>
  <li>It was successfully executing up to now.</li>
  <li>I am SA on my data base.</li>
  <li>I have enough place</li>
  <li>size should be at least 200 M</li>
  <li>I have googled more than 1,5 hours, no success :(</li>
  </ul>
  
  <p>Can someone please help me on this issue? Thanks :)</p>
  
  <p>-- </p>
  
  <p>update1: Could it be that my drop statement, which I have used to drop old tablespases, was not complete? </p>
  
  <pre><code> DROP TABLESPACE SPC_A 
     INCLUDING CONTENTS 
        CASCADE CONSTRAINTS; 
  </code></pre>
  
  <p>--</p>
  
  <p>update2: I have tried this code without any success: </p>
  
  <pre><code>ALTER DATABASE DATAFILE 'SPC_A' OFFLINE DROP;
  </code></pre>
  
  <p>This code cannot works out, since the tablespace has been already deleted</p>
  
  <pre><code>ALTER TABLESPACE example DROP DATAFILE 'SPC_A';
  </code></pre>