If a table is created in the database as "lower_case_table_name", with double quotes, SharePlex cannot replicate it.
For example, if the following table is created:
create table "test" (id number);
select table_name from dba_tables where table_name='test';
It shows up as lower case test.
Here is what is specified in config file:
datasource:o.srcSID
splex.test splex.test targethost@o.trgtSID
sp_ctrl (suntrain3:2200)> activate config mytest
"SPLEX"."TEST" may not be replicated because it's neither a table or a sequence.
This table name cannot be found in the dba_objects and activation fails.
The table name needs to be put in the configuration as "lower_case_table_name", with double quotes and SharePlex will replicate it.
In the example above, this is what the config file should look like:
datasource:o.srcSID
splex."test" splex."test" targethost@o.trgtSID
