ZHZHK001 2019-11-17 12:58 采纳率: 85.7%
浏览 962
已采纳

Navicat同步 为什么缺失右括号 CONSTRAINT问题

  1. 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
;

  • 写回答

1条回答 默认 最新

  • zqbnqsdsmd 2019-11-17 22:45
    关注
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

问题事件

  • 已采纳回答 11月18日