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

Debezium Oracle connector attempting to analyze tables

    XMLWordPrintable

    Details

      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

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: