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

Oracle data pump TEMPLATE_TABLE clause not supported

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 3.0.5.Final
    • 3.0.4.Final
    • oracle-connector
    • None

      Given the following SQL:

      CREATE TABLE "MASTERBILL"."ET$03D5D0AD0001"
          ("USER#", "NAME")
          ORGANIZATION EXTERNAL
          ( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY "DBEXPORT" ACCESS PARAMETERS ( DEBUG = (0 , 0) DATAPUMP INTERNAL
              TABLE "SYS"."KU$_USER_MAPPING_VIEW" TEMPLATE_TABLE "KU$_USER_MAPPING_VIEW_TBL"
              JOB ( "MASTERBILL","SYS_EXPORT_FULL_01",2) WORKERID 1 PARALLEL 1 VERSION '19.3.0.0.0' ENCRYPTPASSWORDISNULL COMPRESSION DISABLED ENCRYPTION DISABLED )
              LOCATION ('bogus.dat') ) PARALLEL 1 REJECT LIMIT UNLIMITED
               AS SELECT /*+ PARALLEL(KU$,1) */ "USER#", "NAME" FROM "SYS"."KU$_USER_MAPPING_VIEW" KU$;
      

      This yields

      extraneous input 'TEMPLATE_TABLE' expecting {'COMPRESSION', 'DATAPUMP', 'DBLINK', 'DEBUG', 'ENCRYPTION', 'ENCRYPTPASSWORDISNULL', 'HADOOP_TRAILERS', 'JOB', 'LOGFILE', 'NOLOG', 'NOLOGFILE', 'PARALLEL', 'VERSION', 'WORKERID', ')
      

              ccranfor@redhat.com Chris Cranford
              ccranfor@redhat.com Chris Cranford
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: