• From: Fuad Arshad <fuadar@xxxxxxxxx>
  • To: paulastankus@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 1 Aug 2006 14:28:29 -0700 (PDT)

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

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.

Groups are talking. WeÂre listening. Check out the handy changes to Yahoo! 

Other related posts: