4 Replies Latest reply: Feb 21, 2012 12:44 AM by 917099 RSS

    Errors ORA-39002,ORA-39070, ORA-29283, ORA-06512, ORA-29283 during import

    917099
      Hi all,
      I am getting errors during import to 10g database using impdp command.

      D:\>impdp nisa_lt/abc123@objtel1 directory=dtpump dumpfile=20120208_expobj.dmp full=y logfile=dbblog.log

      Import: Release 10.2.0.1.0 - Production on Monday, 13 February, 2012 17:16:05

      Copyright (c) 2003, 2005, Oracle. All rights reserved.

      Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
      Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      ORA-39002: invalid operation
      ORA-39070: Unable to open the log file.
      ORA-29283: invalid file operation
      ORA-06512: at "SYS.UTL_FILE", line 488
      ORA-29283: invalid file operation


      dmpfile history:
      Starting "NISA_LT"."SYS_EXPORT_SCHEMA_01": nisa_lt/********@OBJ schemas=nisa_lt directory=dtpump dumpfile=20120208_expobj.dmp logfile=20120208_expobj.log
      ---
      ---
      Master table "NISA_LT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
      ******************************************************************************
      Dump file set for NISA_LT.SYS_EXPORT_SCHEMA_01 is:
      /oradb/OBJ/oraarch/20120208_expobj.dmp
      Job "NISA_LT"."SYS_EXPORT_SCHEMA_01" successfully completed at 15:04:36

      and the dump file was done ftp with bin mode set.

      It'll be really helpful if some one can guide me on this.