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

Debezium Oracle connector attempting to analyze tables

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.0.0.Beta3
    • 1.0.0.Beta1
    • oracle-connector
    • None

    Description

      The Oracle plugin is attempting to execute 'analyze table' commands on other tables/schemas that aren't even in our whitelist.

      Is there a way to bypass this? This is not desirable (will take a long time to execute, and is not even the correct way to gather statistics in 11g/12c).

      java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
      on
      Caused by: Error : 1031, Position : 22, Sql = analyze table MYSCHEMA.MYTABLE compute statistics, OriginalSql = analyze table MYSCHEMA.MYTABLE compute statistics, Error Msg = ORA-01031: insufficient privileges

      Also-where can one pull the source code for the Oracle connector? It is not on github as far as I can tell...I can see the source for other Debezium DB connectors, but not Oracle

      Attachments

        1. debug.log
          90 kB
          Valued Customer

        Activity

          People

            jpechane Jiri Pechanec
            rfenstermacher Valued Customer (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: