ORA-39117: Type needed to create table is not included in
this operation. Failing sql is: string
- 1 Answers
- 3428 Views
- I also Faced
- E-Mail Answers
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 |
NNO-00080: domain "string" cannot be delegated because its parent is already delegated
NID-00390: These files must be writable by this utility.
TNS-12236: TNS:protocol support not loaded
TNS-02510: Invalid numeric data type
ORA-07401: sptrap: cannot restore user exception handlers.
LPX-00239: invalid attribute type "~s"
ORA-01486: size of array element is too large
ORA-30754: column or table string stores objects of only one type
NID-00138: Block verification failed for datafile string (number)
ORA-06916: CMX: error in data read (t_datain)
PCC-02349: precision must be specified for this type
ORA-30500: database open triggers and server error triggers cannot have BEFORE type
Oracle Errors 
