Slow Index Creation

[samc]

Hi all,
I am doing the migration using exp & imp utility. However, I manual create the index & it took so long to create the index on 3 x 2GB tablespace. What should I do in order to improve the index creation performance?

Please advice.

Thanks

[slimdave]

Build lots of indexes at the same time, using the PARALLEL and NOLOGGING keywords, and setting a reasonably large sort_area_size.

[marist89]

Originally posted by samc
Hi all,
I am doing the migration using exp & imp utility. However, I manual create the index & it took so long to create the index on 3 x 2GB tablespace. What should I do in order to improve the index creation performance?

Don't use exp/imp to migrate.