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/