Re: impdp performance
From: Yechiel Adar <adar666_at_inter.net.il>
Date: Mon, 22 Jun 2009 08:32:30 +0300
Message-id: <4A3F176E.6030006_at_inter.net.il>
You can use impdp with:
sqlfile=index.sql,include=index
to get the sql to create all the indexes.
Date: Mon, 22 Jun 2009 08:32:30 +0300
Message-id: <4A3F176E.6030006_at_inter.net.il>
You can use impdp with:
sqlfile=index.sql,include=index
to get the sql to create all the indexes.
A little edit will make all the create index no logging and parallel ans
analyzed.
You get additional bonus as you can then split the index creation to 3-4
parts and run them in parallel.
Adar Yechiel
Rechovot, Israel
Ram Raman wrote:
> Hi all,
>
> We have about 50,000 indexes in this schema. If I exclude
> indexes during import and decide to create them later using Nologging
> and parallel options, do I need to extract the index DDLs for each of
> the indexes and modify the DDL for each of them or is there any quick
> way to set it for all indexes. v 10g. I used a parallelism of 8.
> Thanks.
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 22 2009 - 00:32:30 CDT