Dmp file compatibility issues with impdp (AIX / Windows)
766302Apr 13 2010 — edited Apr 13 2010Hi,
Firstly please go easy on me as i'm new to datapump being an imp/exp stalwart, that said I've received some customer data created using expdp that i must load into our 10.2.0.4 windows environment. The dmp file was exported from a 10.2.0.4 environment running on an AIX server. My immediate concern was compatibility of the dmp file created on different platforms and this was borne out when i tried to read the file using impdp as i got the following, employing these steps :-
SQL> CREATE DIRECTORY dmpdir2 AS 's:\Customer Data\xxxx449';
Directory created.
SQL> grant read ,write on DIRECTORY dmpdir2 to xxxx449 ;
Grant succeeded.
S:\Customer Data\xxxx449>impdp system/xxxxxx directory=dmpdir2 dumpfile=expd
p-coda-daily.dmp remap_schema=codaowner:xxxx449 logfile=dpimp.log
Import: Release 10.2.0.4.0 - 64bit Production on Tuesday, 13 April, 2010 10:28:48
Copyright (c) 2003, 2007, 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-31694: master table "SYSTEM"."SYS_IMPORT_FULL_01" failed to load/unload
ORA-31640: unable to open dump file "s:\Customer Data\xxxx449\expdp-coda-dail
y.dmp" for read
ORA-19505: failed to identify file "s:\Customer Data\xxxx449\expdp-coda-daily
.dmp"
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 3363096253)
Could you please advise if what i'm trying to achieve here is possible ?
If it is what do i need to do differently to enable Oracle running on this windows server to read this AIX created dmp file ?
Many thanks in advance,
Mike.