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

Oracle does not support compression/logging clauses after an LOB storage clause

XMLWordPrintable

      One of our customers has reported a Parsing error with Oracle DB Connector.

      Here is an extract of the error log:

       Error1:

      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement    'create table \"P_BL050044\".CMP4$231516 organization heap    tablespace \"PT_LOB\" lob (FILE_XML,FILE_IMG_F,FILE_IMG_R) store as (tablespace \"PT_LOB\" enable storage in row nocache nologging) compress for all operations nologging as select /*+ DYNAMIC_SAMPLING(0) */ * from \"P_BL050044\".CMP3$231516 mytab;'    mismatched input 'compress' expecting {'AS', 'USAGE', ';'}   

      Error2:

      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'create table \"P_BL050044\".CMP4$231516 organization heap    tablespace \"PT_LOB\" lob (FILE_XML,FILE_IMG_F,FILE_IMG_R) store as (tablespace \"PT_LOB\" enable storage in row nocache nologging) compress for all operations nologging as select /*+ DYNAMIC_SAMPLING(0) */ * from \"P_BL050044\".CMP3$231516 mytab;    extraneous input 'as' expecting      {<EOF>, 'ABORT', 'ABS', 'ACCESS', 'ACCESSED',   . . . .  }

      Attaching the full server log.

              ccranfor@redhat.com Chris Cranford
              fmarchio@redhat.com Francesco Marchioni (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: