RE: Oracle impdp parallel issues
- From: "Ruel, Chris" <Chris.Ruel@xxxxxxx>
- To: "jack@xxxxxxxxxxxx" <jack@xxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 30 May 2014 13:11:13 +0000
For what it is worth, have you verified your directory is pointing to the
correct location?
Also, and I may speak from inexperience here, but, I never use the %U on
import...I specify the files. I have only used %U on export. It may very well
work, just haven’t done that myself.
Does the logfile get written?
Does it work without parallel?
Are these the only tables skipped...do any get imported?
Chris..
Chris Ruel * Oracle Database Administrator
cruel@xxxxxxx<mailto:cruel@xxxxxxx> * Desk:317.759.2172 * Cell 317.523.8482
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Jack van Zanen
Sent: Thursday, May 29, 2014 6:13 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Oracle impdp parallel issues
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
Notice of Confidentiality: **This E-mail and any of its attachments may contain
Lincoln National Corporation proprietary information, which is privileged,
confidential,
or subject to copyright belonging to the Lincoln National Corporation family of
companies. This E-mail is intended solely for the use of the individual or
entity to
which it is addressed. If you are not the intended recipient of this E-mail,
you are
hereby notified that any dissemination, distribution, copying, or action taken
in
relation to the contents of and attachments to this E-mail is strictly
prohibited
and may be unlawful. If you have received this E-mail in error, please notify
the
sender immediately and permanently delete the original and any copy of this
E-mail
and any printout. Thank You.**
Other related posts:
