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

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

      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 - 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 - 64bit
      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:
      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.