Re: impdp performance
Date: Mon, 22 Jun 2009 08:32:30 +0300
You can use impdp with:
to get the sql to create all the indexes.
A little edit will make all the create index no logging and parallel ans
You get additional bonus as you can then split the index creation to 3-4 parts and run them in parallel.
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.