Oracle® Database 8i | 9i | 10g | 11g | 12c | 18c | 19c Error Codes

Information for Database Error Code ORA-39117: Type needed to create table is not included in this operation. Failing sql is: [string]
Oracle® Database Error ORA-39117422/22

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

Cause: 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.

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

Error Type: ORA

Oracle® Database Error Codes 8i | 9i | 10g | 11g | 12c | 18c | 19c

Record: 1/1

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle