This discussion is archived
1 Reply Latest reply: Apr 1, 2013 5:52 AM by Paul M. RSS

IMPDP error

1000268 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points