请教下面SQL的语法如何理解,新建的分区的rule是怎么确定的; 和普通的先创建分区再删除分区有何不同?ALTER TABLE Tbl_date SPLIT PARTITION PART_20100903 AT ( to_date('2010-09-02','YYYY-MM-DD') )
INTO (PARTITION PART_20100901,PARTITION PART_20100903)
INTO (PARTITION PART_20100901,PARTITION PART_20100903)
看上去是把分区表PART_20100903 分为两个分区PART_20100901,PART_20100903不建议 有风险
partition by range(b)
(partition part_20100930 values less than(to_date('2010-09-30','yyyy-mm-dd'))
);查询分区情况:
select table_name, partitioning_type,PARTITION_COUNT,status from user_part_tables;
select table_name, partition_name, partition_position from user_tab_partitions;把上面的分区分开,
ALTER TABLE Tbl_date SPLIT PARTITION PART_20100930 AT ( to_date('2010-09-02','YYYY-MM-DD') )
INTO (PARTITION PART_20100901,PARTITION PART_20100903);再查询分区情况
查询分区情况:
select table_name, partitioning_type,PARTITION_COUNT,status from user_part_tables;
select table_name, partition_name, partition_position from user_tab_partitions;
楼主可以执行这个查询,看high_value数据
select partition_name, high_value from user_tab_partitions where table_name='TBL_DATE'
split的话直接执行语句就可以了,不需要折腾数据.只是要注意索引重建.