4 Replies Latest reply: Sep 24, 2013 9:15 AM by Anar Godjaev RSS

    impdp from multiples files get error

    SigCle

      Hi All,

       

      Need expert help :

      below is database Oracle version :

       

      BANNER

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      PL/SQL Release 11.2.0.3.0 - Production
      CORE 11.2.0.3.0 Production
      TNS for Solaris: Version 11.2.0.3.0 - Production
      NLSRTL Version 11.2.0.3.0 - Production

       

      {code}

      export :

      expdp apps directory=ARCH_DIR dumpfile=FAH_DBDUMP_07072013_28082013_%U.dmp tables=.. parallel=5 logfile=FAH_DBDUMP_07072013_28082013_exp.log

       

      but while want to import with below command :

      impdp apps directory=arch_dir dumpfile=FAH_DBDUMP_02072013_27082013_%U.dmp TABLE_EXISTS_ACTION=APPEND logfile=FAH_DBDUMP_02072013_27082013_imp.log

       

      there's error emerged :

      ORA-39245: import job requires export dump file "FAH_DBDUMP_02072013_27082013_02.dmp"

      ORA-39245: import job requires export dump file "FAH_DBDUMP_02072013_27082013_03.dmp"

      ORA-39245: import job requires export dump file "FAH_DBDUMP_02072013_27082013_04.dmp"

      ORA-39245: import job requires export dump file "FAH_DBDUMP_02072013_27082013_05.dmp"

      ORA-39059: dump file set is incomplete

      {code}

       

      all dump files already placed at proper path based on ARCH_DIR

       

      Any help would be appreciated.

       

      Thanks.

       

      Best Regards,

      Sigcle