SymmetricDS Error while creating Trigger on Oracle DB due to double quotes

32 Views Asked by At

I am using SymmetricDS 3.12.8 trying to synchronize Oracle and PostgreSQL DBs. When SymmetricDS tries to create Oracle triggers it uses double quotes for schema and wrong table name and that is why it says it can't find the table

Error Msg = ORA-00942: table or view does not exist

The trigger creation:

create or replace trigger SYM_ON_I_FOR_SGN_TRC_NTTB_SGN after insert on "schema_name"."table_name"

What I need is to make SymmetricDS to remove double quotes from Oracle Dialect like this:

create or replace trigger SYM_ON_I_FOR_SGN_TRC_NTTB_SGN after insert on schema_name.table_name
0

There are 0 best solutions below