# Table exclusion regex

**URL:** <https://forum.confluent.io/t/table-exclusion-regex/6100>\
**Category:** Managed Connectors\
**Created:** [22 September 2022 08:53 UTC](https://forum.confluent.io/t/table-exclusion-regex/6100 "2022-09-22T08:53:20Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Muthu](https://avatars.discourse-cdn.com/v4/letter/m/bbce88/32.png) [@Muthu](https://forum.confluent.io/u/Muthu)\
**Post date:** [22 September 2022 08:53 UTC](https://forum.confluent.io/t/table-exclusion-regex/6100/1 "2022-09-22T08:53:20Z")

</div>

Hi Team,  
We are using CDC oracle connector to get events from Oracle DB tables.  
Requirement : For ex if we have to include all tables that start with PFL\_ and exclude only one table with name PFL\_BANK\_DATA. I tried adding exclusion regex but it’s not getting excluded, am getting events for that also. Please help or let know if am doing wrongly.  
Below is the config i use:  
{  
“name”: “NEXTGENUSERCDCConnector\_292”,  
“config”:{  
“connector.class”: “io.confluent.connect.oracle.cdc.OracleCdcSourceConnector”,  
“name”: “NEXTGENUSERCDCConnector\_292”,  
“tasks.max”:1,  
“key.converter”: “io.confluent.connect.avro.AvroConverter”,  
“key.converter.schema.registry.url”: “http:/localhost:8081”,  
“value.converter”: “io.confluent.connect.avro.AvroConverter”,  
“value.converter.schema.registry.url”: “http:/localhost:8081”,  
“confluent.topic.bootstrap.servers”:“localhost:9092”,  
“oracle.server”: “ECH-10-170-129-203.xxxx.int”,  
“oracle.port”: 1527,  
“oracle.sid”:“dctf1s”,  
“oracle.username”: “NEXTGENUSER”,  
“oracle.password”: “boss”,  
“start.from”:“snapshot”,  
“redo.log.topic.name”: “redo-topic20”,  
“table.inclusion.regex”:“dctf1s[.]NEXTGENUSER.”,  
“table.exclusion.regex”:“dctf1s[.]NEXTGENUSER.”,  
“table.topic.name.template”: “”,  
“connection.pool.max.size”: 20,  
“confluent.topic.replication.factor”:1,  
“topic.creation.groups”: “redo”,  
“topic.creation.redo.include”: “redo-log-topic”,  
“topic.creation.redo.replication.factor”: 1,  
“topic.creation.redo.partitions”: 1,  
“topic.creation.redo.cleanup.policy”: “insert”,  
“topic.creation.redo.retention.ms”: 120960,  
“topic.creation.default.replication.factor”: 1,  
“topic.creation.default.partitions”: 1,  
“topic.creation.default.cleanup.policy”: “insert”  
}

}