根本的原因是数据库是分区的,而建表的时候没有指定分区键,建主键的时候会出现这个错误
drop table "ARS"."CALL_DISTRACT" ;
CREATE TABLE "ARS"."CALL_DISTRACT"
("CUST_ID" DECIMAL(17, 0),
"PROD_INST_ID" DECIMAL(17, 0) NOT NULL,
"ACC_NBR" VARCHAR(60),
"BEGIN_DATE" DATE,
"END_DATE" DATE
)
DATA CAPTURE NONE
IN "CCP"
partitioning key
(PROD_INST_ID) using hashing
NOT LOGGED INITIALLY;
ALTER TABLE "ARS"."CALL_DISTRACT"
LOCKSIZE ROW
APPEND OFF
NOT VOLATILE
LOG INDEX BUILD NULL;
ALTER TABLE "ARS"."CALL_DISTRACT"
ADD CONSTRAINT "PK_PROD_INST_ID" PRIMARY KEY
("PROD_INST_ID"
);
如果不指定partitioning key 会出现这个错误。
drop table "ARS"."CALL_DISTRACT" ;
CREATE TABLE "ARS"."CALL_DISTRACT"
("CUST_ID" DECIMAL(17, 0),
"PROD_INST_ID" DECIMAL(17, 0) NOT NULL,
"ACC_NBR" VARCHAR(60),
"BEGIN_DATE" DATE,
"END_DATE" DATE
)
DATA CAPTURE NONE
IN "CCP"
partitioning key
(PROD_INST_ID) using hashing
NOT LOGGED INITIALLY;
ALTER TABLE "ARS"."CALL_DISTRACT"
LOCKSIZE ROW
APPEND OFF
NOT VOLATILE
LOG INDEX BUILD NULL;
ALTER TABLE "ARS"."CALL_DISTRACT"
ADD CONSTRAINT "PK_PROD_INST_ID" PRIMARY KEY
("PROD_INST_ID"
);
如果不指定partitioning key 会出现这个错误。