Fabian Bachl
Fabian Bachl

Reputation: 43

Failing table creation using SymmetricDS and Oracle master DB

We have following setup:

So it looks like:

Client: Schema/Service : qwerz; Table: table_a

Master: Schema/Service: dabc_svc.tst.tns; Table: table_a

Our router looks like this:

INSERT INTO SYM_ROUTER (router_id, target_catalog_name, source_node_group_id, target_node_group_id, create_time, last_update_time) values ('client2master', 'dabc_svc.tst.tns','abc_client', 'abc_central', current_timestamp, current_timestamp);

The trigger:

insert into sym_trigger (trigger_id,source_catalog_name, source_table_name,channel_id,last_update_time,create_time) values('trigger_a','qwertz','*','default',current_timestamp,current_timestamp);

If I trigger now an initial load with:

insert into SYM_TABLE_RELOAD_REQUEST (target_node_id, source_node_id, trigger_id, router_id, create_time, create_table, last_update_time) values ('master', 'client_a', 'ALL', 'ALL', current_timestamp, 1, current_timestamp);

SymmetricDS tries to create the tables on Oracle with a statement like this: CREATE TABLE "dabc_svc.tst.tns"."SYM_USER"."TABLE_A" (...);

Which fails with the error “missing or invalid options” on Oracle. It looks to me like the create table statement is wrong, because executing manually CREATE TABLE “TABLE_A" (...); works just fine.

Do I overlook something?

Upvotes: 1

Views: 81

Answers (0)

Related Questions