Partition-level database administration

Table partitioning enables a database administrator to perform some maintenance tasks at one partition at a time. The advantage of most partition-level maintenance is that it can be performed online, and when executed online, the other partitions of a table not being operated on remain accessible by the language clients and other utilities.