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

Oracle alter table drop constraint fails when cascading index

XMLWordPrintable

      Given the following SQL:

      ALTER TABLE PTY_PD_IVSM_MAGR_INFO 
       DROP CONSTRAINT PK_PTY_PD_IVSM_MAGR_INFO 
       CASCADE DROP INDEX;
      

      The Oracle connector will fail to process the DDL because the code does not support the CASCADE DROP INDEX clause when specifying DROP CONSTRAINT.

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

              Created:
              Updated:
              Resolved: