Re: impdp performance

From: Yechiel Adar <>
Date: Mon, 22 Jun 2009 08:32:30 +0300
Message-id: <>

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

Received on Mon Jun 22 2009 - 00:32:30 CDT

Original text of this message