We also ...
1. created tables first ... with no indexes and no constraints.
2. Prepared a constraints script
3. drop all triggers.
4. Imported data in multiple streams (in our case 6 import processes on each node X 2 nodes) with different tables listed in parfile with no constraints, no statistics, we let the indexes be created
5. After imprt Enabled constraints
6. recreate table triggers
7. verify if everything is okay ... if it is, shutdown, cold backup and restart
8. collect stats in multiple streams
9. Enable archivelog mode
10. switch logfiles ...
11. shutdown take full backup
12. database is open for business.
Not all of these will suit you, but importing in multiple streams (even if from the same export file) is beneficial BTW this was when we moved from 8161 to 9201. Kirti's email helped us tune it further.
Raj
-------------------------------------------------------------
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!
*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1
