Hi @Oscar : Table is still there in the database . I just continued this old thread as the error message generated was same and replated to expdp , anyways from next time new thread :) @Orion : RAC or not ? not sure will check once i get back to office. @Edwin : No xml type or lob column in table. SR with oracle is in progress for last few days as per them : Trace of dw : SQL> alter system set events 'sql_trace {process : pname = dw | pname = dm} level=8'; WAIT #47001882895456: nam='wait for unread message on broadcast channel' ela= 1001658 channel context=14216224800 channel handle=14137260376 p3=0 obj#=12756289 tim=1416782389247019 EXEC #47001882895456:c=1000,e=5006933,p=0,cr=4,cu=0,mis=0,r=0,dep=2,og=1,plh=0,tim=1416782389247328 ERROR #47001882895456:err=25228 tim=1416782389247359 CLOSE #47001882895456:c=0,e=24,dep=2,type=0,tim=1416782389247485 ksedmp: internal or fatal error ORA-25228: timeout or end-of-fetch during message dequeue from sys.kupc$que_int.transceive_int *This may be a problem at the AQ$ layer causing master process to signal object doesn't exist. * On Mon, Nov 24, 2014 at 10:37 AM, edwin devadanam <edwin_kodamala@xxxxxxxxx> wrote: > 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.4 and later* > Information in this document applies to any platform. > SYMPTOMS > > ORA-600 [QMCXEGETPFXID2] is raised from DataPump Export EXPDP 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 skipped due 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 TABLE with XMLTYPE > column and database character set is not UTF8 > > > SOLUTION > > Apply Patch 19051460 to resolve the ora-600 from table export failure. > > > REFERENCES > > BUG:19051460 - ORA-600 [QMCXEGETPFXID2] ON EXPDP OF TABLE WITH XMLTYPE > > > thanks, > Edwin.K > > > On Monday, November 24, 2014 10:03 AM, sumit Tyagi < > dba.tyagisumit@xxxxxxxxx> 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 > > ****************************************************************************** > > > 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* > > > -- *--* *BR* *Sumit Tyagi* *+91-7829543355*