My Oracle Support Banner

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

Last updated on AUGUST 01, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
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=<DUMP FILE>.dmp logfile=<LOG FILE>.log


and this returned the following errors:

...
KUP-11007: conversion error loading table "<OWNER>"."<TABLE NAME>"
ORA-26060: Cannot convert type identifier for column <COLUMN NAME>
KUP-11007: conversion error loading table "<OWNER>"."<TABLE NAME>"
ORA-26062: Cannot continue from previous errors.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.