title: CREATE and DROP TABLESPACE Oracle
body: <p>I have created this tablespace</p>
  
  <pre><code>CREATE TABLESPACE IA643_TBS
  DATAFILE 'IA643_dat' SIZE 500K
  AUTOEXTEND ON NEXT 300K MAXSIZE 100M;
  </code></pre>
  
  <p>I tried to drop it using this command</p>
  
  <pre><code>DROP TABLESPACE IA643_TBS;
  </code></pre>
  
  <p>And it said that it was dropped, when I tried to create it again, I got those error messages:</p>
  
  <pre><code>ERROR at line 1: 
  ORA-01119: error in creating database file 'IA643_dat' 
  ORA-27038: created file already exists 
  OSD-04010: &lt;create&gt; option specified, file already exists 
  </code></pre>
  
  <p>How can I delete the datafile and recreate the tablespace with same file names?</p>