title: How to partition an oracle table by a date column?
body: <p>I have a table in oracle:</p>
  
  <pre><code>CREATE TABLE transaction (
      id INT NOT NULL,
      accountnumber VARCHAR NOT NULL,
      stmtvaluedate DATE NOT NULL,
      ...
  )
  </code></pre>
  
  <p>And I want to partition this table by the stmtvaluedate column. My goal is to create a new partition after a month have passed.</p>
  
  <p>Is there any good script, for it? Or I have to create static numbers of partitions?</p>
  
  <p>The best would be: if a month have passed, a new partition will be created automatically.</p>
  
  <p>Can anyone give me an example about how to partition a table by a date column after every month? If the automatically partitioning is impossible, than I would need an example, which creates partitions to a year from now by a date column, about every month.</p>
  
  <p>Thanks!</p>