Re: URGENT: IMPORT HELP

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.

Other related posts: