Do an export with direct=Y and while importing specify recordlength to its max value.And as told by pando do not import the indexes.It would faster for index creation after only data has been imported.
Make sure u set the sort_area_size=1GB with nologging clause.
regards
anandkl




Reply With Quote