Re: URGENT: IMPORT HELP
- From: Fuad Arshad <fuadar@xxxxxxxxx>
- To: fuadar@xxxxxxxxx, paulastankus@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 1 Aug 2006 14:32:20 -0700 (PDT)
what i meant to say was
imp rows=yes indexes=no constraints=no
imp rows=no indexes=yes constraints=yes
and do the prereqs below
----- Original Message ----
From: Fuad Arshad <fuadar@xxxxxxxxx>
To: paulastankus@xxxxxxxxx; oracle-l <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, August 1, 2006 4:28:29 PM
Subject: 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:
