-
Title
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%") -
Description
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
-
Cause
The keyword ‘expand’ is missing in the config file. -
Resolution
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.