title: How to add the datafile to tablespace which is already full?
body: <p>Consider the Initial Tablespace declared as</p>
  
  <pre><code>CREATE TABLESPACE tbs_perm_02
    DATAFILE 'tbs_perm_02.dat' 
      SIZE 10M
      REUSE
      AUTOEXTEND ON NEXT 10M MAXSIZE 200M;
  </code></pre>
  
  <p>The declared space is exhausted and i need to add more datafile. </p>
  
  <p>As </p>
  
  <pre><code>ALTER TABLESPACE tbs_perm_02
  ADD DATAFILE 'tbs_perm_02.dat'
    SIZE 20M
    AUTOEXTEND ON;
  </code></pre>
  
  <p>The point here is that the table place is already exhausted its initially declared value of 10M Plus 200M. But When We ALTER the tablespace with extended datafile, wll that work out? Or is there another way to extend or alter in this case. </p>