create table ptemp
(
PKey integer,
vone integer,
vtow integer
)
partition by range(PKey, vone)
(
partition p1 values less than (3, 2),
partition p2 values less than (4, 4),
partition p3 values less than (maxvalue, maxvalue)
)
插入数据,结果
pkey=1 vone=3 插入到p1里面
pkey=2 vone=3 插入到p2里面
Why?
|