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

Oracle DATADUMP DDL cannot be parsed

XMLWordPrintable

      In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.

      Bug report

      For bug reports, provide this information, please:

      What Debezium connector do you use and what version?

      1.9.0

      What is the connector configuration?

      <Your answer>

      What is the captured database version and mode of depoyment?

      (E.g. on-premises, with a specific cloud provider, etc.)

      Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

      What behaviour do you expect?

      Correctly process DDL statements.

      What behaviour do you see?

      Connector fails.

      Do you see the same behaviour using the latest relesead Debezium version?

      No, not able to replicate the exact same version and DDL as in production.

       

      Logs:

       

      CREATE TABLE "ET$xxxx" 
         (    "MANDT", 
          "WERKS", 
          "MATNR", 
          "GZEQUNR", 
          "GZEQUNED", 
          "MODNE", 
          "NAME1", 
          "MAKTX"
         ) ORGANIZATION EXTERNAL 
          ( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY "DMPDP" ACCESS PARAMETERS ( DEBUG = (0 , 0) DATAPUMP INTERNAL TABLE "xxxx"."xxxx"  JOB ( "GGS","SYS_EXPORT_TABLE_01",1) WORKERID 1 PARALLEL 1 VERSION '11.2.0.0.0' ENCRYPTPASSWORDISNULL  COMPRESSION ENABLED  ENCRYPTION DISABLED  DBLINK 'TOPRD') LOCATION ('xxxx.dat') )  PARALLEL 1 REJECT LIMIT UNLIMITED
          AS SELECT /*+ PARALLEL(KU$,1) */ "MANDT", "WERKS", "MATNR", "GZEQUNR", "GZEQUNED", "MODNE", "NAME1", "MAKTX"
          FROM RELATIONAL("xxxx"."xxxx" @TOPRD NOT XMLTYPE) AS OF SCN 216399751091 KU$ 
         ;

              ccranfor@redhat.com Chris Cranford
              dz902 Dai Z (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: