Re: Disable redo writing
From: Ilmar Kerm <ilmar.kerm_at_gmail.com>
Date: Thu, 27 Jan 2011 11:55:47 +0200
Message-ID: <AANLkTim+RG8RyX51bW-dqMtQjjbMEKCo9vWBdQNQAS-2_at_mail.gmail.com>
You can set the tablespaces before import to NOLOGGING mode and enable logging after the import is done.
I'm not sure about importing over network link, but if you run both expdp and impdp locally using PARALLEL parameter, then indexes are also created in parallel.
Date: Thu, 27 Jan 2011 11:55:47 +0200
Message-ID: <AANLkTim+RG8RyX51bW-dqMtQjjbMEKCo9vWBdQNQAS-2_at_mail.gmail.com>
You can set the tablespaces before import to NOLOGGING mode and enable logging after the import is done.
I'm not sure about importing over network link, but if you run both expdp and impdp locally using PARALLEL parameter, then indexes are also created in parallel.
Ilmar
On Thu, Jan 27, 2011 at 11:43 AM, Yechiel Adar <adar666_at_inter.net.il> wrote:
> This import generate about 60-70 GB of archive logs, so I think I can call
> it MASSIVE.
-- Ilmar Kerm -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 27 2011 - 03:55:47 CST