Most importantly, have you checked the alert log if at all there are any error whil import was in progress, specifically related with temporary tablespace?
as you said indexes are big, they will need a huge sort area in temporary tablespace for the same.
Are you using temporary tablespace as LMT ?




Reply With Quote