partition by list的问题

显示全部楼层 · 2005-10-30 17:05:33

create table
customer
(col values)
partition by list (state_name)
partition yankees values ('New York','Maine'),
partition rebels values ('North Carolina', South Carolina');
能不能设定除了上面列出的数值以后，其它所有的数据归入另一个分区中，像PARTITION part_415 values less than(MAXVALUE)一样。
哪位给个语法，谢谢！！！

千问 · 2005-10-30 17:05:33

SQL> CREATE TABLEcustomer
2 (state_name VARCHAR2(20),comments VARCHAR2(20))
3PARTITION BY LIST (state_name)
4 (PARTITION rebels VALUES ('North Carolina', 'South Carolina'),
5PARTITION yankees VALUES ('New York','Maine'),
6PARTITION OTHERS VALUES(DEFAULT));
Table created.
Elapsed: 00:00:00.14
SQL> insert into customer values ('Virginia','None');
1 row created.
Elapsed: 00:00:00.01
SQL> select * from customer partition (others);
STATE_NAME
COMMENTS
---------------------------------------- ----------------------------------------
Virginia
None
Elapsed: 00:00:00.01
SQL>