Re: Performance considerations during Oracle imp/load

Ora Dummy wrote:
> Okay. What if I import once (nevermind the poor performance with
> commit=Y. If I don't specify it rollback segment will run out), and
> then unload it to a flat file and then use load to do it next time on.
> If load is considered, what will be
> the parameters to consider to speed up the load.
>
> Ora Dummy
>

Increase size of the rollback segment(s). And, even when I never benchmarked SQL*Loader against import, I get the feeling import is faster.

What version of Oracle? External table possible, with a parallel insert into production tables?!?

-- 
Regards,
Frank van Bortel