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*