Since you use IGNORE=Y option I presume the table exists in your destination database before you start the import. If there are indexes defined on it, this will considerably slow down the import and the option INDEXES=N will not be of much help. If this is the case drop the indexes prior to import and recreate them afterwards (probably with PARALLEL and NOLOGGING).




Reply With Quote