Bug report

For bug reports, provide this information, please:

The connector throws exception:

DDL statement couldn't be parsed. Please open a Jira issue with the statement 'revoke select on ORDERS from SV_DEBEZIUM_CDC;

What Debezium connector do you use and what version?

1.9.5.Final

What is the connector configuration?

{
  "name": "debezium-orders-connector",
  "config": {
    "connector.class" : "io.debezium.connector.oracle.OracleConnector",
    "tasks.max" : "1",
    "database.server.name" : "debezium-orders-connector",
    "database.hostname" : "db_server_ip",
    "database.url": "jdbc:oracle:thin:@db_server_ip:1521:ORCLCDB",
    "database.user" : "connector_db_user",
    "database.password" : "connector_db_pwd",
    "database.dbname" : "ORCLCDB",
    "database.connection.adapter" : "logminer",
    "log.mining.strategy": "online_catalog",
    "lob.enabled": "true",
    "database.history.kafka.bootstrap.servers" : "kafka:9092",
    "database.history.kafka.topic": "local.db.history-changes",
    "snapshot.mode": "schema_only",
    "table.include.list": "C##TESTER.ORDERS",
    "decimal.handling.mode": "string",
    "transforms": "Reroute, RerouteSchemaTopic",
    "transforms.Reroute.type": "io.debezium.transforms.ByLogicalTableRouter",
    "transforms.Reroute.topic.regex": ".*(.ORDERS)", 
    "transforms.Reroute.topic.replacement": "local.order-out",
    "transforms.RerouteSchemaTopic.type": "io.debezium.transforms.ByLogicalTableRouter",
    "transforms.RerouteSchemaTopic.topic.regex": "debezium-orders-connector", 
    "transforms.RerouteSchemaTopic.topic.replacement": "local.db.schema-changes",
    "key.converter": "org.apache.kafka.connect.json.JsonConverter",
    "key.converter.schemas.enable": "false",
    "value.converter": "io.confluent.connect.avro.AvroConverter",
    "value.converter.schema.registry.url": "http://schema-registry:8081",
    "value.converter.schemas.enable": "false",
    "database.history.store.only.captured.tables.ddl": "true"
  }
}

What is the captured database version and mode of depoyment?

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.13.0.0.0

What behaviour do you expect?

no errors

What behaviour do you see?

errors in logs - connector stops

Do you see the same behaviour using the latest relesead Debezium version?

Did not check

Do you have the connector logs, ideally from start till finish?

attached