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

Exclude usernames at transaction level

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 1.8.0.Alpha1
    • 1.7.0.Beta1
    • oracle-connector
    • None
    • False
    • False
    • Undefined

        The original requirements

      I'd like to add the ability to exclude a list of usernames from the results returned by the logminer query. The use case I have is that we have multiple Oracle instances that are using shareplex to replicate data between the databases. We want to run an instance of debezium against each database so we'd like to filter out the replication changes made by the shareplex user.

      Oracle only write the username in the first record of a transaction in redo log, if the transaction spans two logminer queries, the returned records in the second query will have an UNKNOWN user name, so the record will not be filtered with current implementation.

      We can change the implementation to exclude username at transaction level.

            ccranfor@redhat.com Chris Cranford
            wizhu@cisco.com Willie Zhu (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: