错误代码:
#列表分区
create table studentTest2(
s_id number(3) primary key,
s_name varchar2(10)
)
partition by list(s_name)(
partition p1 values ('张三','张二'),
partition p2 values ('张一','网一')
);
insert into studentTest2 values (1,'张三');
insert into studentTest2 values (2,'张二');
insert into studentTest2 values (3,'张一');
insert into studentTest2 values (4,'李一');
insert into studentTest2 values (5,'网一');
解决办法:
在分区里加 partition p3 values (default)
不过你要先drop再create了。。。