list partition(values(default))

Besides the method listed aboved,there is also a simple method:

After create the partitions we add a partition as list:
SQL> alter table stringvalue add partition p161
2 values(DEFAULT);

It mean that,when you insert a new row with a value that not exist in the exist partition,
the row will be insert into the partition p161.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20709695/viewspace-702950/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20709695/viewspace-702950/