DataPump Import (IMPDP) Fails With Errors KUP-11007 ORA-26060 ORA-26062 (Doc ID 795369.1)

Last updated on APRIL 15, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 15-Apr-2013***

Symptoms

You started a DataPump import (impdp) job with the following parameters:

#> impdp directory=data_pump_dir transform=oid:n parallel=4 dumpfile=msmdb10g.dmp logfile=imp.log


and this returned the following errors:

...
KUP-11007: conversion error loading table "PRODIT2"."DELAY_QUEUE_TABLE"
ORA-26060: Cannot convert type identifier for column USER_DATA
KUP-11007: conversion error loading table "PRODIT2"."DELAY_QUEUE_TABLE"
ORA-26062: Cannot continue from previous errors.

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