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

DDL couldn't be parsed: 'analyze table schema.table estimate statistics sample 5 percent;'

XMLWordPrintable

      We are running debezium 1.6 on an Oracle 19c database. Right after the connector switched from snapshot to streaming mode debezium crashed with the following error:

       

      Caused by: io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'analyze table schema.table estimate statistics sample 5 percent;'

      The analyze statement looks fine to me and I can't spot any issue with the table DDL:

      CREATE TABLE "schema"."table"
      ( "col1" DATE NOT NULL ENABLE,
      "col2" NUMBER(*,0),
      "col3" VARCHAR2(70),
      "col4" VARCHAR2(70),
      "col5" VARCHAR2(8),
      "col6" VARCHAR2(1),
      "col7" VARCHAR2(250) NOT NULL ENABLE
      ) SEGMENT CREATION IMMEDIATE
      PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
      NOCOMPRESS LOGGING
      STORAGE(INITIAL 778240 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
      PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
      BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
      TABLESPACE "DATA" ;

              ccranfor@redhat.com Chris Cranford
              rc.hueber@gmail.com Robin Hueber (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: