Import too slow

another suggestion. while importing use the parameter analyze=n

Quote:

---

Originally posted by tharakab
another suggestion. while importing use the parameter analyze=n

---

Hi,
can u explain why should I use analyze
while import..
And how the commit will slowdown the import process..
thanx in advance.
Pratheesh

Hi

Analyze=n means that your asking the import utility not to recalculate statistics..

You can try this..
create an index file of all sql statements containing the indexes..

and then import the table and data..
run the sql file for indexes in sqlplus with the nologiing cluase appended..

and also try to put a high value for buffer parameter depending upon available memory..

regards
Hrishy