Oracle impdp parallel issues

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Fri, 30 May 2014 08:13:10 +1000
Message-ID: <CAFeFPA85od=wh9ZZrf4RjzE72afTd62s-nt3rTV-=P+=J2HzXw_at_mail.gmail.com>

Hi All,

My co-worker is doing a reorg/rebuild of cluster tables which involves expdp and impdp
He exports the table into multiple files using the %U parameter drops the clustered table and imports it again.
During the import he gets below error.
The files are there, permissions are proper and when not running in parallel it finishes without issues.
We just need the parallel to make it go faster and fit withing the go-live cutover window.

ORA-31693: Table data object "XYZ"."METER_READING_S11Y10M08" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-31640: unable to open dump file
"/oraarchive101/exp/expdp_meter_y10_04.dmp" for read
ORA-19505: failed to identify file
"/oraarchive101/exp/expdp_meter_y10_04.dmp"
ORA-27041: unable to open file
IBM AIX RISC System/6000 Error: 22: Invalid argument Additional information: 2
ORA-31693: Table data object "XYZ"."METER_READING_S11Y10M01" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-31640: unable to open dump file
"/oraarchive101/exp/expdp_meter_y10_05.dmp" for read
ORA-19505: failed to identify file
"/oraarchive101/exp/expdp_meter_y10_05.dmp"
ORA-27041: unable to open file

Parameter File :

userid=/
schemas=xyz
directory=meter_exp_arch
dumpfile=expdp_meter_y11_%U.dmp
EXCLUDE=STATISTICS
logfile=impdp_meter_y11.log
parallel=24

This is Oracle 10.2.0.4 on AIX.

Has anyone seen this before and know of a solution?

Jack van Zanen

---

This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation

--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 30 2014 - 00:13:10 CEST