title: Table partitions in oracle with alter command
body: <p>I have to create partitions dynamically for oracle table in a JAVA program , from user input. If user enters 3 I have to make 3 partitions. previously there is a table with around 100 columns. But my problem is when I am executing the below query in Sql Developer it is giving error as shown below.</p>
  
  <p>Is there any alternative to add three or more partitions at a time with alter command or must I alter the table for three times for three partitions? </p>
  
  <p>I am using 'Oracle 9i', suggest some thing</p>
  
  <p>Thanks in advance  </p>
  
  <p>Sql Query    </p>
  
  <pre><code>ALTER TABLE table_01  add 
  partition p2 values less than(20),
  partition p3 values less than(30),
  partition p4 values less than(40);
  </code></pre>
  
  <p>Error </p>
  
  <pre><code>Error report -
  SQL Error: ORA-14043: only one partition may be added
  14043. 00000 -  "only one partition may be added"
  *Cause:    ALTER TABLE ADD PARTITION contained descriptions of more than  one
         partition to be added
  *Action:   Ensure that the statement contains exactly one partition
         definition and that it does not contain any commas
  </code></pre>