1.先创建一个分区表test(没有MAXVALUE分区)
HR@PROD>create table hr.test(
2 id number,
3 name varchar2(20))
4 PARTITION BY RANGE (id)
5 (PARTITION p1 VALUES LESS THAN (10),
6 PARTITION p2 VALUES LESS THAN (20),
7 PARTITION p3 VALUES LESS THAN (30)
8 );
Table created.
2.查看test分区表的分区信息
HR@PROD>select TABLE_NAME,PARTITION_NAME
2 from user_tab_partitions
3 where table_name='TEST';
TABLE_NAME PARTITION_NAME
------------------------------ ------------------------------
TEST P1
TEST P2
TEST P3
3.添加分区
HR@PROD>
HR@PROD>create table hr.test(
2 id number,
3 name varchar2(20))
4 PARTITION BY RANGE (id)
5 (PARTITION p1 VALUES LESS THAN (10),
6 PARTITION p2 VALUES LESS THAN (20),
7 PARTITION p3 VALUES LESS THAN (30)
8 );
Table created.
2.查看test分区表的分区信息
HR@PROD>select TABLE_NAME,PARTITION_NAME
2 from user_tab_partitions
3 where table_name='TEST';
TABLE_NAME PARTITION_NAME
------------------------------ ------------------------------
TEST P1
TEST P2
TEST P3
3.添加分区
HR@PROD>