Speeding up imports

Hi folks,

Is there are anyway to speed up import? That thing is taking forever!
Should I set commit=n (I set buffer to 300m, and my TEMP is 500M), should I do analyze=n?
We have a Sun 450 with 4 processors, and the machine is 50%+ idle (also Oracle 7.3.4 on top).
I don't want to do parallel tablespace_imports, b/c I will probobly have problems with constraints which are going to take forever to figure out... unless you know an easy way out :)

Thanx

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email