KEYSCOLS and wildcards
edited May 15, 2013 12:56PM in GoldenGate, Streams and Distributed Database (MOSC) 11 commentsAnswered ✓
Hi,
I'm trying to set up a GoldenGate extract parameter file (ver. 11.2) and I have one schema with some tables that don't have PK or UK. I'd like to use KEYCOLS for those tables and a wildcard like "SCHEMA.*" for the rest.
After reading MOS article "Can I Use A Wildcard In An Extract TABLE Statement For All Of The Tables Except One That Does Not Have A Primary Key? [ID 970419.1]" I understand that if I also want to set up DDL replication the ONLY alternatives are:
1) Set up a single GG parameter file without using wildcards and listing every single table of the schema using KEYCOLS where needed.
0