title: Drop partitions older than 2 months
body: <p>I have a table with partition based on date field. Now, I have to write a procedure to drop all partitions older than 2 months i.e. test_date is older than 2 months. How do I do it?</p>
  
  <pre><code>create table test_table
  (
  test_id number,
  test_date date,
  constraint pk_test primary key (test_id)
  )
  partition by range (test_date)
  (
  PARTITION pt01122012 VALUES LESS THAN (TO_DATE('01-DEC-
  2012', 'DD-MON-YYYY')),
  PARTITION pt01022013 VALUES LESS THAN (TO_DATE('01-FEB-
  2013', 'DD-MON-YYYY')),
  PARTITION pt01042013 VALUES LESS THAN (TO_DATE('01-APR-
  2013', 'DD-MON-YYYY')),
  PARTITION pt01062013 VALUES LESS THAN (TO_DATE('01-JUN-
  2013', 'DD-MON-YYYY')),
  PARTITION pt01082013 VALUES LESS THAN (TO_DATE('01-AUG-
  2013', 'DD-MON-YYYY'))
  );
  </code></pre>
  
  <p>Thanks in advance...</p>