title: Split a list partition (set of values) into multiple single value partitions in Oracle
body: <p>I have a table which is partitioned by list and each partition have multiple values. For example:</p>
  
  <pre><code>partition by list (COL1)
  (
    partition GROUP_1 values ('VAL1','VAL2','VAL3')
  )
  </code></pre>
  
  <p>This table has huge data and sometimes, multiple sessions are trying to access same block and I am facing read by other session problem. So, I am thinking of changing the structure to below:</p>
  
  <pre><code>Alter Table Table_1
  Split Partition GROUP_1 INTO
    partition GROUP_2 values ('VAL1'),
    partition GROUP_3 values ('VAL2'),
    partition GROUP_4 values ('VAL3')
  )  PARALLEL 5;
  </code></pre>
  
  <p>I cannot use DBMS_REDEF as it will cause object invalids. I am trying to use Split Partitions but I am getting ORA-14028. </p>
  
  <p>What would be the best way of achieving this?</p>
  
  <p>Thanks a lot.</p>