title: "Dynamic" partitions in oracle 11g
body: <p>I have a log table with a lot of information.
  I would like to partition it into two: first part is the logs from the past month, since they are commonly viewed. Second part is the logs from the rest of the year (Compressed).</p>
  
  <p>My problem is that all the examples of partitions where "up until 1/1/2013", "more recent than 1/1/2013" - That is with fixed dates...</p>
  
  <p>What I am looking for/expecting is a way to define a partition on the last month, so that when the day changes, the logs from 30 days ago, are "automatically" transferred to the compressed partition.</p>
  
  <p>I guess I can create another table which is completley compressed and move info using JOBS, but I was hoping for a built-in solution.</p>
  
  <p>Thank you.</p>