Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-3641

Oracle DDL parser fails on CREATE TABLE: mismatched input 'maxtrans' expecting {'AS', ';'}

XMLWordPrintable

      The following problems occurred when I use the debezium 1.6.0.Beta2 , and the version of oracle is 1.93. Please refer to the attachment for details.

      About the ddl, please see as follows:

      CREATE TABLE IDATA_BAIIR.CUST_INFO    (ID NUMBER(20) NOT NULL ENABLE,  CUST_NAME VARCHAR2(200 CHAR) NOT NULL ENABLE,  CUST_NAME_PY VARCHAR2(500 CHAR),  CUST_NAME_PY_SZ VARCHAR2(50 CHAR),  CUST_NAME_ABBR VARCHAR2(100 CHAR),  CUST_NAME_ABBR_PY VARCHAR2(300 CHAR),  CUST_NAME_ABBR_PY_SZ VARCHAR2(50 CHAR),  CUST_NAME_EN VARCHAR2(100 CHAR),  CUST_TYPE NUMBER(10),  CUST_STATUS NUMBER(10),  CUST_LEVEL NUMBER(10),  MEMO VARCHAR2(500 CHAR),  TEL_NUM VARCHAR2(100 CHAR),  FAX_NUM VARCHAR2(100 CHAR),  INTERNET_ADDRESS VARCHAR2(200 CHAR),  COMPANY_ADDRESS VARCHAR2(200 CHAR),  POST_CODE VARCHAR2(50 CHAR),  EMAIL_ADDRESS VARCHAR2(200 CHAR),  CUST_VALID_FLAG NUMBER(1),  EXP_DATE DATE,  CERT_TYPE NUMBER(10),  CERT_NUM VARCHAR2(100 CHAR),  CERT_CUST_NAME VARCHAR2(200 CHAR),  RISK_LEVEL NUMBER(10),  FXPP_CONFIRM_PROCESS NUMBER(10),  FXPP_CONFIRM_PROCESS_INFO NUMBER(10),  SDX_INFO_AUDITOR VARCHAR2(100 CHAR),  SDX_NEW_COM NUMBER(1),  ECIF_OTC_FLAG NUMBER(1),  AUDIT_STATUS NUMBER(1),  IS_VALID NUMBER(1) DEFAULT 1 NOT NULL ENABLE,  CREATE_TIME DATE,  CREATOR NUMBER(20),  CREATOR_NAME VARCHAR2(30 CHAR),  MODIFY_TIME DATE,  MODIFIER NUMBER(20),  MODIFIER_NAME VARCHAR2(30 CHAR)   )   tablespace BIGDATADBT pctfree 10 initrans 1 maxtrans 255 storage ( initial 192K next 1M minextents 1 maxextents unlimited );
      

              ccranfor@redhat.com Chris Cranford
              27939976@qq.com Fly Yang (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: