title: Changing tablespace increment size
body: <p>One of our datafiles hit the max of 32G.  So, we created a 2nd datafile in that tablespace.</p>
  
  <p>However, we forgot to give a default NEXT size.  So, file 1 has a NEXT of 50MB.  And file 2 has a NEXT of 8k.</p>
  
  <p>These are locally managed, so, I am guessing the only thing to do is create a new tablespace, and move all the objects.  Or is there another solution?  One question:  How do I move TYPES?   Do I need to drop &amp; recreate those?  Which will invalidate a ton of things.......</p>
  
  <p>Any suggestions?  Can I isolate the objects in just that datafile?</p>
  
  <p>Thanking you.</p>