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

Debezium Oracle connector attempting to analyze tables


    • 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
      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

        1. debug.log
          90 kB
          Valued Customer

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