Re: expdp query parameters
From: VKS <mailvks_at_gmail.com>
Date: Wed, 20 Apr 2011 10:18:55 -0500
Message-ID: <BANLkTi=z49HaYAiBsYe+igU7+BLRUXHXfw_at_mail.gmail.com>
Yes you can as many as you want.
Date: Wed, 20 Apr 2011 10:18:55 -0500
Message-ID: <BANLkTi=z49HaYAiBsYe+igU7+BLRUXHXfw_at_mail.gmail.com>
Yes you can as many as you want.
This looks like EBS db, so I will assume you are going to some version of
11g.
Definitely exclude XLA packages during import (expdp does not have this
problem), they take 30-45 min to recreate and take 40+ hours to import,
there are bugs open but no patch.
exclude=PACKAGE_BODY:" LIKE 'XLA_%'" => instead of Query
drop recreate on source - may need you to do a large compile of invalids and regen forms too adding to downtime.
You also want to add parallel=n depending on CPU's and I/O bandwidth you
have.
Thanks !
VKS
On Wed, Apr 20, 2011 at 9:08 AM, Kumar Madduri <ksmadduri_at_gmail.com> wrote:
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 20 2011 - 10:18:55 CDT