Navicat同步 为什么缺失右括号 CONSTRAINT问题
问题描述:
- Navicat同步 为什么缺失右括号 问题已经确定出现在CONSTRAINT内容中 我如果同步的话应该怎么更改啊
2.这一段什么意思啊
LOGGING NOCOMPRESS
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
我感觉意思是 日志设置为不压缩 ……
————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
CREATE TABLE "SCRD_MAIN" (
"APS_NBR" NUMBER(2) ,
"REMARK" VARCHAR2(80 BYTE) ,
"CHG_DAT" CHAR(8 BYTE) ,
"CRT_DAT" CHAR(8 BYTE) ,
"OACC_INST_NO" VARCHAR2(20 BYTE) ,
"CRT_TLR" VARCHAR2(10 BYTE) ,
"CLS_DAT" CHAR(8 BYTE) ,
"ACC_NUM" VARCHAR2(35 BYTE) ,
CONSTRAINT "U_F_AGR_CRD_MAIN" UNIQUE ("CRD_NO", "AREA_NO") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE,
CONSTRAINT "SYS_C0018202" CHECK ("AREA_NO" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE,
CONSTRAINT "SYS_C0018203" CHECK ("DATA_DATE" IS NOT NULL"CRD_NO" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE,
CONSTRAINT "SYS_C0018204" CHECK ("BRANCH_ID" IS NOT NULL"CUST_NO" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE,
CONSTRAINT "SYS_C0018205" CHECK ("DATA_DATE" IS NOT NULL"ASSU_MODE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE
)
LOGGING NOCOMPRESS
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;