How to fix the Oracle error ORA-39117: Type needed to create table is not included in this operation. Failing sql is: string?

In this post, you’ll learn more about the Oracle ErrorORA-39117: Type needed to create table is not included in this operation. Failing sql is: string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-39117: Type needed to create table is not included in this operation. Failing sql is: string

Reason for the Error ORA-39117: Type needed to create table is not included in this operation. Failing sql is: string

A create table was attempted and a dependent type does not exist in the dumpfile or on the target database. Either the export or the import Data Pump job was a table mode job and types are not included in table mode jobs.

How to fix the Error ORA-39117: Type needed to create table is not included in this operation. Failing sql is: string ?

You can fix this error in Oracle by following the below steps

Determine which type(s) are missing and create them on the target system and run the Data Pump import job again.