Re: concurrent imports?

From: Tanel Poder <tanel_at_@peldik.com>
Date: Sat, 29 Mar 2003 10:56:38 +0200
Message-ID: <3e855f08$1_1@news.estpak.ee>

Hi!

When exporting, no redo is generated. When importing a lot of it may be generated if you don't use direct option or _disable_logging. Also, exporting doesn't require any index maintenance or scanning (usually), but import will require index upates. I'd recommend to import with constraints=n indexes=n at first and applying them after all data is already loaded.

Tanel.

"Tim Smith" <timasmith_at_hotmail.com> wrote in message news:a7234bb1.0303280917.68f2f04_at_posting.google.com...
> Hi,
> I did concurrent exports, such that each export wrote to a different
> disk and this seems to have increased the throughput nicely.
> How about concurrent imports - any reason for problems? Again
> assuming I spread the I/O. Oracle 7.3.3.6 160GB on VMS (yes we are
> upgrading next week... just making a copy of the live database...).
>
> Tim
Received on Sat Mar 29 2003 - 02:56:38 CST