为表删除一个分区,数据和分区都被删除,如果要保留数据,请合并分区-------------------oracle文档说---------------
drop_partition_clause
This clause removes partition partition, and the data in that partition, from a partitioned table. If you want to drop a partition but keep its data in the table, you must merge the partition into one of the adjacent partitions.
drop_partition_clause
This clause removes partition partition, and the data in that partition, from a partitioned table. If you want to drop a partition but keep its data in the table, you must merge the partition into one of the adjacent partitions.
1从p1分区中导出(export)数据
2发出语句删分区p1:
alter table abc drop partition p1;
3将导出的数据导入(import)到p2分区,相应的局部索引分区也合并.方法二:
1那立临时表
2将abc表的p1分区与临时表abc_temp交换
3发出语句删除分区区小事p1
4插入abc_tmep表中的数据,从而实现p1分区到p2分区移动数据