create table INVENTORY_INTERIM (
shopid VARCHAR2(6) not null,
placeid VARCHAR2(20) not null,
goodsid INTEGER not null
)
PARTITION BY LIST (supid)
(
PARTITION P01 VALUES ('112'),
PARTITION P02 VALUES ('8518'),
PARTITION P03 VALUES ('5876'),
PARTITION P04 VALUES ('4524'),
PARTITION P05 VALUES ('3534'),
PARTITION P06 VALUES ('3565'),
PARTITION P07 VALUES ('1148'),
PARTITION P08 VALUES ('24184'),
PARTITION P09 VALUES ('3854'),
PARTITION P10 VALUES ('3852'),
PARTITION P99 VALUES (DEFAULT)
)