title: Can oracle tablespaces automatically add smallfile datafiles?
body: <p>Using Oracle managed files I can create my tablespace like this:</p>
  
  <pre><code>CREATE TABLESPACE users;
  </code></pre>
  
  <p>It will autoextend but as I understand it smallfile datafiles have a maximum size. So I then need to do:</p>
  
  <pre><code>ALTER TABLESPACE users ADD DATAFILE;
  ALTER TABLESPACE users ADD DATAFILE;
  ALTER TABLESPACE users ADD DATAFILE;
  </code></pre>
  
  <p>Just wondering if there was a way to get oracle to automatically add another datafile when it tries to autoextend past its largest possible size?</p>