Import with index=n ,buffer=the max possible,
create the indexes by using the indexfile option.
use alter session set sort_area_size= the max possible.
create the temp tablespace with intial and next big sizes.
run the index file ...
everything will be fast.




Reply With Quote