Replicate tables with names with mixed-case and spaces
Hi,
I'd like to know how to replicate Oracle tables with mixed-case names and/or have spaces considering:
- Source DB: 9.2.0.4. Destination DB: 11.2.0.3
- Source GG: 11.1.1.1.4, Destination GG: 11.2.1.0.19
For the extracts I've tried
TABLE schema.*;
TABLE schema."*";
TABLE schema."tAblE ";
with no success.
In some cases tables are ignored, while in others I get the following error:
2014-03-21 13:52:55 INFO OGG-01517 Position of first record processed Sequence 63449, RBA 82951696, SCN 0.3975440662, 21/03/2014 13:49:12.
TABLEWildcard resolved (entry SCHEMA.*):
Table SCHEMA.TABLA 2;
Source Context :
SourceModule : [er.main]
SourceID : [er/rep.c]
SourceFunction : [get_map_entry]
SourceLine : [8792]
2014-03-21 13:53:20 ERROR OGG-00212 Invalid option for MAP: 2.
I been searching GG 11.1 documentation, MOS notes and Google but I haven't found a way to replicate those tables.