Re: Importing and indexing large tables

There are basically two alternatives: find a faster export solution or find a way to run export faster.
On 1 Apr 1997 20:16:08 GMT, Apowell.Dgo_at_btinternet.com (Alan Jeskins-Powell) wrote:

>Does anyone have any ideas on how we can spped the process up so that we
>can a) fit the exp/import into a working weekend and b) still allow time
>for harware/software upgrades as well.

You have two alternatives: find a faster way to unload data, or find a way to let export run faster.

The first might be answered by any of a number of products keyed to the 'fast unload' niche. Platinum has one; I think BMC does as well, and I dare say the other db mgmt vendors have something to offer.

The second depends on the machine you are using. Are you using direct mode for export? If it is an SMP machine, can you run several exports concurrently (by schema or functional groups of tables or whatever scheme you wish to use)? Can you get hold of a solid-state disk, export to it, then back up to tape while the database is back up available for use? Is this part of a 'belt and suspnders' approach to supplement archivelog mode? If not, archivelog mode gives you a number of alternatives for backup of large databases. Ocopy does as well.

Hope this gives you some ideas.

Regards,
jh

Jared Hecker              | HWA Inc. -
jared_at_hwai.com            |  Oracle Architecure and Administration
76276.740_at_compuserve.com  |  serving the NJ/NYC region