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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25100: TABLESPACE option can only be used with ALTER INDEX REBUILD

1 Answers  


NNL-00834: Slowest delete processing time: string

1 Answers  


ORA-09854: snyPortInfo: bad return code from request.

1 Answers  


NZE-28855: Unsupported SSL operation

1 Answers  


ORA-12585: TNS:data truncation

1 Answers  






QSM-01020: materialized view, string, is ineligible

1 Answers  


ORA-00126: connection refused; invalid duplicity

1 Answers  


SQL*Loader-00464: file offset for beginning of lob is string

1 Answers  


ORA-16172: archive logs detected beyond Terminal End-Of-Redo

1 Answers  


ORA-08233: smsdes: cannot unmap SGA

2 Answers  


TNS-00005: INTCTL: error while sending request to the Navigator

1 Answers  


ORA-12209: TNS:encountered uninitialized global

1 Answers  


Categories