Home -> Mailing Lists -> Oracle-L -> Re: Oracle impdp parallel issues

Re: Oracle impdp parallel issues

From: edwin devadanam <edwin_kodamala_at_yahoo.com>
Date: Mon, 24 Nov 2014 05:07:30 +0000
Message-ID: <925348297.16687.1416805650332.JavaMail.yahoo_at_jws10730.mail.gq1.yahoo.com> 





check this out


Data Pump Export Of An XML Table Fails With ORA-600[qmcxeGetPfxId2] (Doc ID 1921325.1)




 


APPLIES TO:



 


Oracle Database - Enterprise Edition - Version 11.2.0.4and later



Information in this document applies to any platform.



SYMPTOMS



 


ORA-600 [QMCXEGETPFXID2] is raised from DataPump ExportEXPDP of XMLType table.




 


Errors ora-31693, ora-29913, ora-600 are seen in export log




 


ORA-31693: Table data object"EVT"."DOSYA" failed to load/unload and is being skippeddue to error:



ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout



ORA-00600: internal error code, arguments: [qmcxeGetPfxId2],[], [], [], [], [], [], [], [], [], [], []




 



 


CAUSE



 


Bug 19051460: ORA-600 [QMCXEGETPFXID2] from EXPDP of TABLEwith XMLTYPE column and database character set is not UTF8




 



 


SOLUTION



 


Apply Patch 19051460 to resolve the ora-600 from tableexport failure.




 



 


REFERENCES



 


BUG:19051460 - ORA-600 [QMCXEGETPFXID2] ON EXPDP OF TABLEWITH XMLTYPE




thanks,Edwin.K 



     On Monday, November 24, 2014 10:03 AM, sumit Tyagi <dba.tyagisumit_at_gmail.com> wrote:
   



 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 

****************************************************************************** 






BRSumit 


On Sun, Jun 1, 2014 at 4:41 PM, Jack van Zanen <jack_at_vanzanen.com> 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_at_gmail.com> 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_at_vanzanen.com> 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 calloutORA-31640: unable to open dump file "/oraarchive101/exp/expdp_meter_y10_04.dmp" for readORA-19505: failed to identify file "/oraarchive101/exp/expdp_meter_y10_04.dmp"ORA-27041: unable to open fileIBM AIX RISC System/6000 Error: 22: Invalid argumentAdditional information: 2ORA-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 calloutORA-31640: unable to open dump file "/oraarchive101/exp/expdp_meter_y10_05.dmp" for readORA-19505: failed to identify file "/oraarchive101/exp/expdp_meter_y10_05.dmp"ORA-27041: unable to open file
Parameter File :


userid=/schemas=xyzdirectory=meter_exp_archdumpfile=expdp_meter_y11_%U.dmpEXCLUDE=STATISTICSlogfile=impdp_meter_y11.logparallel=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 






-- 




--BRSumit Tyagi+91-7829543355


   


--



http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 24 2014 - 06:07:30 CET












Original text of this message