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-31609: error loading file "string" from file system directory "string"

1 Answers  


EXP-00038: Bad Hash cluster id in clu$

1 Answers  


RMAN-06408: recovery catalog upgraded to version string

1 Answers  


RMAN-00701: SCRIPT requires that CATALOG be specified on the command line

1 Answers  


RMAN-08153: deleted global script: string

1 Answers  


ORA-25212: invalid PRIORITY specified when using sequence deviation

1 Answers  


ORA-03125: client-server protocol violation

1 Answers  


CLSS-00001: skgxn not active

1 Answers  


ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }

1 Answers  


ORA-06034: NETDNT: connect failed, partner exited unexpectedly

1 Answers  


ORA-02823: Buffer is not aligned.

1 Answers  


ORA-26011: Cannot load type string into column string in table string

1 Answers  


Categories