Re: impdp performance

From: Ram Raman <veeeraman_at_gmail.com>
Date: Mon, 22 Jun 2009 08:18:02 -0500
Message-ID: <effc058d0906220618y6151079fkc957915c9326dfa8_at_mail.gmail.com>

Thanks Yechiel, That is what I did last time. I wanted to check if there was something new.

It was not a little edit though. It was not just search and replace. The index definitions of some indexes had parallel already built in them, which caused them to fail after I added my own parallel clause. I guess I will do it that way.

On Mon, Jun 22, 2009 at 12:32 AM, Yechiel Adar <adar666_at_inter.net.il> wrote:

> 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-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 22 2009 - 08:18:02 CDT