GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center