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 220.127.116.11.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 18.104.22.168.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?
This sounds more like a corrupt dump file. or something similar. Are you changing versions from the export database to the import database? If you are importing on the same database, have you tried using network import to see if that works?
Please post the true versions of the databases. LIke 22.214.171.124, not 11gr2.
Both source and target are - 126.96.36.199.1202.
Please note that
1. I am using WINSCP to copy the dump file to a WINDOWS box and then transferring the dump to target.
2. I am getting the same error when I am trying to import the dump to a windows installation.
Much thanks for your replies.
Would like to add just a simple line that if I do the import on the same server (source and destination is same box), the impdp works just fine.
I would update after changing the version of WINSCP.