The rolling window concept is a made up of partitions. These partitions span a given amount of days, in my case I have a requirement for 90 days. To support the rolling window we have created software to drop and create partitions as needed to support 90 days. So, you end up with exactly the amount of days you want and you can move partitions around for max. performance. Also, dropping a partition is easy, you truncate it, then drop it. This prevents you from doing deletes and creating unneeded redo.

I believe Oracle provides software support for automatic rolling, but I am not sure, never had a need to research it.

The problems with partitions is the indexing, which is limited to global or local. Local indexes require little maintenance, but are not as optimal as global indexes in performance. Global indexes on the other hand are great performers, but require maintenance after almost any DDL operation.