Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Foreign key creation is very slow

528639Apr 2 2008 — edited Apr 4 2008

Hello,

We are about to migrate a database from 9iR2 to 10g by doing export/import.
One of the last steps of the migration, after the import, is to create constraints and indexes. The foreign key creation process is lasting about 7 hours, and this is something we cannot afford. How could we speed up this process of foreign key creation?

Thanks in advance,

Eva

Locked Post

New comments cannot be posted to this locked post.

Locked on May 2 2008

Added on Apr 2 2008

#general-database-discussions

7 comments

2,609 views