Activating a config with wildcard has error messages about tables with wildcards "Object may not be replicated because it's neither a table nor a sequence. Skipping ("OWNER"."TABLENAME%") (4330952)

The following errors are observed when activating a config with wildcards:

Warning  2016-08-23 15:17:46.860886 9604 1 Activation: Object may not be replicated because it's neither a table nor a sequence. Skipping ("OWNER"."TABLENAME%")    (activating sid sourceSID) [module ocf]

sp_ctrl (alvsupu15:5438)> activate config config2

   No valid tables were found in the config.

Here is the config file:

datasource:o.ORA11GR2

#source tables      target tables           routing map

OWNER.TABLENAME%  OWNER.TABLENAME%  server_name@o.targetSID

When using wildcard notations in a config file, the entry for the wildcard should precede the keyword ‘expand’ otherwise the activation process will not be able to parse it correctly resulting in the above error. To correct the problem (taking our sample config file as an example), the following will be the correct entry:

datasource:o.ORA11GR2

#source tables      target tables           routing map

expand OWNER.TABLENAME%  OWNER.TABLENAME%  server_name@o.targetSID

Once the syntax is fixed, activate the config file again.