分区表 负分区 -split的使用
SQL> create table part1 (col1 varchar2(10), levelcol number(10)) partition by range(levelcol)
(partition part_max values less than (0)) tablespace users;
Table created.
SQL> alter table part1 split partition part_max at (-10) into (partition part_10, partition part_max);
Table altered.
SQL> alter table part1 split partition part_10 at (-20) into (partition part_20, partition part_10);
Table altered.
SQL> COL HIGH_VALUE FOR A30;
SQL> select partition_name,high_value from dba_tab_partitions where table_name='PART1';
PARTITION_NAME HIGH_VALUE
------------------------------ ------------------------------
PART_MAX 0
PART_10 -10
PART_20 -20
SQL>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/13165828/viewspace-606990/ ，如需转载，请注明出处，否则将追究法律责任。
