guideline for creating different extract/replicat groups
edited Jun 5, 2012 6:45AM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered ✓
Hi, I would appreciate any real life examples of how to do extracts for
one major schema with 2 hundreds tables, some tables are active, some has
logsements, some clobs.
Most of them have primary index. around 100 tables have clobs in several columns.
What is the best way to group extracts?
How to provide best performance ? Is it possible I just create extract group based on schema, like table schemaname.*?
Will that cause any performance issues?
This way will be simple enough so I don't have to key in each individual table, right?
Thank you in advance.
Most of them have primary index. around 100 tables have clobs in several columns.
What is the best way to group extracts?
How to provide best performance ? Is it possible I just create extract group based on schema, like table schemaname.*?
Will that cause any performance issues?
This way will be simple enough so I don't have to key in each individual table, right?
Thank you in advance.
0