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

Oracle DDL Parser Error

    XMLWordPrintable

Details

    Description

      database verson: oracle database 19c 

      exec ddl: 

      CREATE TABLE CUSTOMERS (
        id NUMBER(9) GENERATED BY DEFAULT ON NULL AS IDENTITY  NOT NULL PRIMARY KEY,
        first_name VARCHAR2(255) NOT NULL,
        last_name VARCHAR2(255) NOT NULL,
        email VARCHAR2(255) NOT NULL UNIQUE
      );
      

       

      When I set SnapshotMode to schema_only, it will query DDL by executing :

      select dbms_metadata.get_ddl('TABLE','CUSTOMERS1','DEBEZIUM') from dual;:
      

      result :

       CREATE TABLE "DEBEZIUM"."CUSTOMERS" (
      
      "ID" NUMBER(9,0) GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE, 
      
      "FIRST_NAME" VARCHAR2(255) NOT NULL ENABLE, 
      
      "LAST_NAME" VARCHAR2(255) NOT NULL ENABLE, 
      
      "EMAIL" VARCHAR2(255) NOT NULL ENABLE,
      
       PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE "USERS" ENABLE, 
      
      UNIQUE ("EMAIL") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE "USERS" ENABLE ) 
      
      SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "USERS";
      

       
      Among them, "MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE" causes a parsing error

       

       

      Attachments

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            zhenglc1990@126.com lincheng zheng (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            8 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: