Oracle Solution for Error ora-39117

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

What triggered 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.

What should we do to fix it:

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