Delete Mode Functionality

[MichalisDBA]

Can we have a mode option to DELETE table data alogn with where clause etc.?

For example

######################## ReplicadB General Options ########################
mode=delete
jobs=1
fetch.size=10000
verbose=true
############################# Soruce Options ##############################
source.connect=jdbc:oracle:thin:@10.1.0.10:1521:TEST
source.user=USER
source.password=PASS

source.table=USER.TABLE
source.where=ID > 10

We can not give TRUNCATE permissions to a user to a specific table. You have to grant them on all tables and schemas and you can not use sink.disable.truncate=false on other modes, complete etc.

That way we can first run replicadb to DELETE the table and then do a COMPLETE or INCREMENTAL insert.