title: From Range Partition to Range-Interval
body: <p>I would like to move from Range Partition to Range-Interval, but my current table has a partition on <code>MAXVALUE</code> and the column used for partitioning allows null values :(</p>
  
  <p>E.g.: Say we have:</p>
  
  <pre><code>create table a (b number)
  partition by range (b) (
    PARTITION p0 VALUES LESS THAN (10),
    PARTITION p1 VALUES LESS THAN (50),
    PARTITION p2 VALUES LESS THAN (MAXVALUE)
  );
  </code></pre>
  
  <p>Then we populate:</p>
  
  <pre><code>INSERT INTO a(b) VALUES (1);
  INSERT INTO a(b) VALUES (11);
  INSERT INTO a(b) VALUES (51);
  INSERT INTO a(b) VALUES (null);
  </code></pre>
  
  <p>To be able to move to interval, we need to remove the partition with <code>MAXVALUE</code>, therefore, other values should be moved to a new partition.<br/>
  51 is not a problem, I would create partition where with <code>VALUES LESS than 100</code>, but what about <code>NULL</code> ones?</p>
  
  <p>I was thinking about changing to something like  partition by range <code>(NVL(b,0))</code>, but I am scared about that having to reprocess the whole table (not possible, real table has a lot of data).</p>
  
  <p>Any idea?</p>