Impdp fails with KUP-11007 / ORA-1403 when importing table with Xmltype column (Doc ID 1509989.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Standard Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Data Pump Import (impdp) of a table which uses XMLTYPE columns terminates with errors when importing into a database based on multi-byte character set.

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
KUP-11007: conversion error loading table "TC1"."TAB1"
ORA-01403: no data found
ORA-31693: Table data object "TC1"."TAB1"
failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-26062: Can not continue from previous errors.

 

ANALYSIS
To gather further trace information the impdp could be re-executed while the following event is enabled:

  alter system set events = '1403 trace name ERRORSTACK level 3';

This would create a trace file which confirms the current SQL Statement for the failing impdp session:

----- Error Stack Dump -----
ORA-01403: no data found
----- Current SQL Statement for this session (sql_id=agtj50h1m9xdz) -----
BEGIN :1 := sys.kupc$que_int.attach_queue(:2, :3, :4); END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x8f3232a0       338  package body SYS.DBMS_PRVTAQIS
0x8f3232a0       814  package body SYS.DBMS_PRVTAQIS
0x91d038c8      6214  package body SYS.DBMS_AQADM_SYS
0x91f264d8       230  package body SYS.KUPC$QUE_INT
0x91f264d8      1387  package body SYS.KUPC$QUE_INT
0x85a58f78         1  anonymous block
0x91f17c78       110  package body SYS.KUPC$QUEUE_INT
0x85a65f90      1149  package body SYS.KUPW$WORKER
0x85a6b420         2  anonymous block

 

STACK TRACE

kgeselv ksesecl0 psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool ...

 


 

Changes

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms