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
Printable View
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
Build lots of indexes at the same time, using the PARALLEL and NOLOGGING keywords, and setting a reasonably large sort_area_size.
Don't use exp/imp to migrate.Quote:
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?