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

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

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: