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

Debezium Oracle connector attempting to analyze tables

XMLWordPrintable

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

      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

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

                Created:
                Updated:
                Resolved: