使用分区表的另一个优点是，可以轻松地在表中添加新数据(作为新的数据分区)，同时可以轻松地删除并存档老数据。
Another advantage of using partitioned tables is that new data can be easily added to a table (as another data partition) while old or obsolete data can be easily removed and archived.
TableName：按照名称指定将从中删除分区的分区表。
TableName: Identifies the partitioned table, by name, that a partition is to be removed from.
那意味着，无论何时添加或删除分区，都必须在分区表的所有现有索引中添加或删除对应记录。
This meant that whenever partitions were added or removed, corresponding records had to be added to or removed from any indexes that existed for the table.
正如可以向分区表添加或附加新分区一样，也可以删除现有分区。
Just as you can add or attach new partitions to a partitioned table, you can also remove existing partitions.
IBMTSOM使用范围分区实现事件表，所以您可以分离一个分区，将分离的分区保存在一个外部存储上，或者删除所分离的分区。
IBM TSOM USES range partitioning for event tables, so you can detach a partition, archive the detached partition on an external storage, or drop the detached partition.
一旦表q 1_2010_sales变得可用，可以删除它(以删除数据)，或者将其添加到另一个分区表(例如，以对其存档)。
Once the table Q1_2010_SALES becomes available, you can either drop it (to delete the data) or attach it to another partitioned table (for example, to archive it).
客户想删除除时间维(表是在这一列上进行数据分区的)以外的其他维上的大量数据。
A customer wants to delete large amounts of data on other dimensions than time (which is the column that the table is data partitioned on).
硬盘软故障的数据恢复主要可以从以下几个方面入手：主引导区恢复、分区表恢复、DBR修复零磁道损坏的修复以及文件误删除的数据恢复。
The data recovery of hard disk software failure can be solved by the following ways, the recovery of main boot partition, partition table, DBR, zero track and the file deleted by mistakes.
硬盘软故障的数据恢复主要可以从以下几个方面入手：主引导区恢复、分区表恢复、DBR修复零磁道损坏的修复以及文件误删除的数据恢复。
The data recovery of hard disk software failure can be solved by the following ways, the recovery of main boot partition, partition table, DBR, zero track and the file deleted by mistakes.
应用推荐