Parallelised referential constraints creation
I'm running an Oracle 11.1 DB. I need to import referential constraints into some of the table, but the import takes 10 hours to complete. I have 32 CPUs in the server.
I come across a note saying that i could parallelized the foreign key constraints creation and validation by alter the table degree to higher value e.g 12.
I just want to clarify if this is really help? any other thing that i need to do other than just issue alter table (tablename) parallel 12;?
Appreciate of any advise given.
Thanks