为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: DM8
【操作系统】:centos7
【CPU】:
【问题描述】*:数据库脚本导入失败,之前该脚本在其他达梦数据库中,是导入成功的
CREATE TABLE "T_REALORDERTRADEDETAIL"
(
"ID" NUMBER(38,0) NOT NULL,
"TRADEOBJID" NUMBER(38,0) NOT NULL,
"BROKERID" VARCHAR2(128) NULL,
"INVESTORID" VARCHAR2(128) NOT NULL,
"INSTRUMENTID" VARCHAR2(128) NOT NULL,
"ORDERREF" VARCHAR2(32) NULL,
"USERID" VARCHAR2(128) NULL,
"EXCHANGEID" VARCHAR2(32) NOT NULL,
"TRADEID" VARCHAR2(64) NULL,
"DIRECTION" CHAR(1) NOT NULL,
"ORDERSYSID" VARCHAR2(64) NOT NULL,
"PARTICIPANTID" VARCHAR2(128) NULL,
"CLIENTID" VARCHAR2(128) NULL,
"TRADINGROLE" CHAR(1) NULL,
"EXCHANGEINSTID" VARCHAR2(32) NULL,
"OFFSETFLAG" CHAR(1) NOT NULL,
"HEDGEFLAG" CHAR(1) NULL,
"PRICE" NUMBER NOT NULL,
"VOLUME" NUMBER(38,0) NOT NULL,
"TRADEDATE" VARCHAR2(9) NOT NULL,
"TRADETIME" VARCHAR2(9) NOT NULL,
"TRADETYPE" CHAR(1) NULL,
"PRICESOURCE" CHAR(1) NULL,
"TRADERID" VARCHAR2(64) NULL,
"ORDERLOCALID" VARCHAR2(13) NULL,
"CLEARINGPARTID" VARCHAR2(11) NULL,
"BUSINESSUNIT" VARCHAR2(21) NULL,
"SEQUENCENO" NUMBER(38,0) NULL,
"TRADINGDAY" NUMBER(38,0) NOT NULL,
"SETTLEMENTID" NUMBER(38,0) NULL,
"BROKERORDERSEQ" NUMBER(38,0) NULL,
"COMMISSION" NUMBER DEFAULT 0
NULL,
"CLOSEPROFIT" NUMBER DEFAULT 0
NULL,
"CLOSEPROFIT2" NUMBER DEFAULT 0
NULL
);
ALTER TABLE "T_REALORDERTRADEDETAIL" ADD CONSTRAINT "SYS_C0029864" PRIMARY KEY("ID") ;
ALTER TABLE "T_REALORDERTRADEDETAIL" ADD CONSTRAINT "CONS134219922" UNIQUE("TRADEOBJID","TRADEID","EXCHANGEID","TRADINGDAY","ORDERSYSID") ;
[执行语句4302]:
ALTER TABLE "T_REALORDERTRADEDETAIL" ADD CONSTRAINT "CONS134219922" UNIQUE("TRADEOBJID","TRADEID","EXCHANGEID","TRADINGDAY","ORDERSYSID") ;
执行失败(语句4302)
-2109: 第1 行附近出现错误:
无效的约束名[CONS134219922]
直接空库里执行显示sql没问题,可能是你约束名跟已有库里对象名冲突了。可以检查下原来库中是否已经存在该名字,或者尝试换个新约束名再创建。
