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

Improve snapshot SELECT overrides for Oracle connector

    Details

    • Type: Enhancement
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Explained
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: core-library
    • Labels:
      None

      Description

      There is already an implementation for snapshot select override (predicates). Oracle's predicate can be improved further by specifying "AS OF SCN" predicate.

      This issue is created to address that.

      Proposed solution:

      Given below predicate:

      snapshot.predicate[SRV_EVENT = WHERE applied_to_class = 'UNIT'

      This can be appended with placeholder %scn% to create the resulting predicate for oracle:

      snapshot.predicate[SRV_EVENT = #scn# WHERE applied_to_class = 'UNIT'

      #scn# will then be replaced with "AS OF SCN XXXXXXXX", where XXXXXXXX is the SCN number.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                daniel.andemichael Daniel Andemichael
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: