【 使用环境 】测试环境
【 OB or 其他组件 】
【 使用版本 】4.2.0
报错如下：
(conn=1671107) ORA-00904: invalid identifier ‘SEQUENCE.NEXTVAL’ in ‘SEQ_NO’ Query: CREATE TABLE “TD_CDMCP” (
“W1GMN2” VARCHAR2(200 CHAR),
“W1BINU” VARCHAR2(10 CHAR),
“W1TRNR” VARCHAR2(20 CHAR) NOT NULL,
“W1TRDT” VARCHAR2(10 CHAR),
“W1IPOD” VARCHAR2(10 CHAR),
“W1DTCP” VARCHAR2(10 CHAR),
“W1RLBL” VARCHAR2(20 CHAR),
“W1RTRA” VARCHAR2(20 CHAR),
“W1TATO” VARCHAR2(20 CHAR),
“W1TERM” VARCHAR2(10 CHAR),
“W1CSTY” VARCHAR2(10 CHAR),
“W1MNDE” NUMBER(10,0) DEFAULT 0,
“W1DPTY” VARCHAR2(10 CHAR),
“W1CVF1” VARCHAR2(100 CHAR),
“W1CRSP” VARCHAR2(10 CHAR),
“W1INRT” VARCHAR2(11 CHAR),
“W1CPFQ” VARCHAR2(10 CHAR),
“W1DDWI” VARCHAR2(10 CHAR),
“W1FLRD” VARCHAR2(10 CHAR),
“W1ZWRA” VARCHAR2(20 CHAR),
“W1TWDA” VARCHAR2(20 CHAR),
“W1BPTT” VARCHAR2(20 CHAR),
“W1BTRE” VARCHAR2(20 CHAR),
“W1DPYA” VARCHAR2(20 CHAR),
“W1APAM” VARCHAR2(20 CHAR),
“W1AGBL” VARCHAR2(20 CHAR),
“W1AGOB” VARCHAR2(20 CHAR),
“TRAN_DATE” DATE NOT NULL,
“SEQ_NO” NUMBER(15,0) DEFAULT SEQUENCE.NEXTVAL NOT NULL,
CONSTRAINT “TD_CDMCP_OBPK_1698200426790396” PRIMARY KEY (“W1TRNR”, “TRAN_DATE”)
) Parameters: []
源端数据表为：
CREATE TABLE “DMSCNDA1”.“TD_CDMCP” (
“W1GMN2” VARCHAR2(200),
“W1BINU” VARCHAR2(10),
“W1TRNR” VARCHAR2(20),
“W1TRDT” VARCHAR2(10),
“W1IPOD” VARCHAR2(10),
“W1DTCP” VARCHAR2(10),
“W1RLBL” VARCHAR2(20),
“W1RTRA” VARCHAR2(20),
“W1TATO” VARCHAR2(20),
“W1TERM” VARCHAR2(10),
“W1CSTY” VARCHAR2(10),
“W1MNDE” NUMBER(10) DEFAULT 0,
“W1DPTY” VARCHAR2(10),
“W1CVF1” VARCHAR2(100),
“W1CRSP” VARCHAR2(10),
“W1INRT” VARCHAR2(11),
“W1CPFQ” VARCHAR2(10),
“W1DDWI” VARCHAR2(10),
“W1FLRD” VARCHAR2(10),
“W1ZWRA” VARCHAR2(20),
“W1TWDA” VARCHAR2(20),
“W1BPTT” VARCHAR2(20),
“W1BTRE” VARCHAR2(20),
“W1DPYA” VARCHAR2(20),
“W1APAM” VARCHAR2(20),
“W1AGBL” VARCHAR2(20),
“W1AGOB” VARCHAR2(20),
“TRAN_DATE” DATE,
“SEQ_NO” NUMBER(15) GENERATED BY DEFAULT AS IDENTITY minvalue 1 maxvalue 9999999999999999999999999999 increment by 1 start with 1 cache 20 noorder nocycle CONSTRAINT “TD_CDMCP_OBNOTNULL_1698200426790345” NOT NULL ENABLE,
CONSTRAINT “TD_CDMCP_OBPK_1698200426790396” PRIMARY KEY (“W1TRNR”, “TRAN_DATE”)
) COMPRESS FOR ARCHIVE REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 TABLESPACE “ENS_DM_TBS”;