Originally posted by amir_magdy
dropping and recreating the partition every day is not a good idea since it will be time consuming, and requires DBA intervention.
Well, no it doesn't actually. You can have a scheduled job set up through DBMS_JOB to create new partitions and drop old ones automatically - any worthwhile DBA could do that, it ain't rocket science and the operation would not be time-consuming to run either.

You can also hedge your bets a little by creating the partitions a week in advance.