This discussion is archived
5 Replies Latest reply: May 29, 2012 5:34 AM by N K RSS

4-5 schemas, one main schema has thousands tables, how to extract?

849425 Newbie
Currently Being Moderated
Hi, I would appreciate any real life examples of how to do extracts for one major schema with thousands tables, some tables are active, some has logsements, some clobs.

Most oof them have primary index.

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points