Oracle Error Message
ORA-39117: Type needed to create table is not included in this operation. Failing sql is: string
Reason for the Error
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.
Solution
Determine which type(s) are missing and create them on the target system and run the Data Pump import job again.