CODEWITHSUNDEEP
oracle-databasesymmetricds
Adelin
Adelin

Reputation: 19011

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

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

Upvotes: 0

Views: 48

Answers (0)

Related Questions