paula, i normally do it in the following steps. imp with all constraints(disable them),indexes(drop indexes),triggers disabled(dont drop them). toad does a winderful job of disabling them if i may say and imp will bring back all the constraints pk's and fk's imp with index=y constraints=y makes life much simpler and the import much faster ----- Original Message ---- From: Paula Stankus <paulastankus@xxxxxxxxx> To: oracle-l <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, August 1, 2006 4:19:05 PM Subject: Re:URGENT: IMPORT HELP Using Oracle 8.1.7, Solaris 2.9 Trying to load a large amount of data using import. The schema needs to be the same and only the data reloaded. There are triggers, constraints (pk, fk, etc.) and pk indexes. I have been loading with pk's enabled and pk indexes (not fk and fk indexes) and the process is very slow. I have been running the import with statistics=n, indexes=n I am tempted to disable all constraints and drop pk indexes but I am afraid that I might have trouble creating the pk's properly. Can I used the indexfile option to create the pk's properly and will this make a significant difference in the import. What about after insert triggers? What is the best way to handle the after insert triggers? Any help would be appreciated. I have been spending a lot of time with this data load. Thanks, Paula Groups are talking. WeÂre listening. Check out the handy changes to Yahoo! Groups.