Re[2]: Oracle impdp parallel issues
- From: Orion ten <orionten@xxxxxxxxxxx>
- To: dba.tyagisumit@xxxxxxxxx <dba.tyagisumit@xxxxxxxxx>
- Date: Mon, 24 Nov 2014 07:49:58 +0300
Hi
if it's RAC env, try using cluster=n and post the error if any.
--
Orion
Monday, 24 November 2014, 10:01am +05:30 from sumit Tyagi
<dba.tyagisumit@xxxxxxxxx>:
HI Guys,
Same issue with expdp . Please help . Any recommendations .
Starting "SYS"."SYS_EXPORT_TABLE_01": AS SYSDBA directory=EXPDP_21NOV14
dumpfile=expdp_23Nov14_LISTING_%U logfile=expdp_23Nov14_LISTING.log
tables=IME.BLS_MLSBLUE_LIST exclude=constraint,ref_constraint,index,statistics
parallel=4
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 89.94 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/TRIGGER
ORA-31693: Table data object " IME.BLS_MLSBLUE_LIST " failed to load/unload and
is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-08103: object no longer exists
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
BR
Sumit
On Sun, Jun 1, 2014 at 4:41 PM, Jack van Zanen < jack@xxxxxxxxxxxx > wrote:
>Unfortunately not,
>
>Another member of the list pointd to a bug in impdp with parallel that as of
>yet is unresolved..
>Oracle has confirmed the bug, lets see if they come back with something.
>
>We are using this because of a bug we were hitting when moving database from
>tru64 to AIX and 9i to 10g (11g not supported). All clustered tables got
>messed up during the process so after migration we have to export, drop,
>recreate and import many TB of data.
>Oracle have been very ordinary in their support, even though we are paying for
>extended support.
>
>Thanks
>
>Jack
>
>
>On Sunday, June 1, 2014, David Barbour < david.barbour1@xxxxxxxxx > wrote:
>>Is this a RAC database? I've seen this on a RAC when the dump directory
>>isn't shared across the nodes.
>>
>>
>>On Thu, May 29, 2014 at 5:13 PM, Jack van Zanen < jack@xxxxxxxxxxxx > wrote:
>>>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
>
>
>--
>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
--
--
BR
Sumit Tyagi
+91-7829543355
Other related posts:
- » Re[2]: Oracle impdp parallel issues - Orion ten
