1 Reply Latest reply: Apr 1, 2013 7:52 AM by Paul M. RSS

    IMPDP error

    1000268
      Hi All,

      Oracle 11g R1 - Solaris 10.

      I am trying to expdp a particular table:

      expdp / directory=DATA_PUMP_DIR tables=GILE00.photo dumpfile=GILE00_PHOTO.dmp logfile=GILE00_PHOTO.log

      -----This works perfectly.

      When trying to import to a different server,
      ====================================================
      impdp / directory=DATA_PUMP_DIR tables=GILE00.photo dumpfile=GILE00_PHOTO.dmp logfile=GILE00_PHOTO.log

      I get the below error:

      Import: Release 11.1.0.7.0 - 64bit Production on Friday, 29 March, 2013 5:35:08

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

      Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      ORA-39002: invalid operation
      ORA-31694: master table "OPS$ORACLE"."SYS_IMPORT_TABLE_01" failed to load/unload
      ORA-31640: unable to open dump file "/u00/app/oracle/admin/PHARMA3/exp/photo_new.dmp" for read
      ORA-19505: failed to identify file "/u00/app/oracle/admin/PHARMA3/exp/photo_new.dmp"
      ORA-27046: file size is not a multiple of logical block size
      Additional information: 1
      ====================================================
      ----The table has a column of BLOB datatype. Is that the casue of the error?

      Regards