Oracle Error ORA-39779: type “string”.”string” not found or conversion to latest version is not possible

Oracle Error Message

ORA-39779: type “string”.”string” not found or conversion to latest version is not possible

Reason for the Error

Unable to import table data using the specified type. The type was nonexistent in the database or the input type could not be converted to the existing type. The reasons why a conversion was not possible are:

1. The version of the type in the database was greater than the version of the type at export time because 1 or more attributes have been added or dropped from the type.

2. If the type existed in the database prior to the import operation, then its internal identifier may not match the internal identifier of the type from the export database. The identifiers must match for an import to succeed.

Solution

Ensure the types in the database match those at export time.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...