Category Archives: IMP Database Error Messages

IMP-00072: Warning: The object table’s object identifier is invalid

oracle

IMP-00072: Warning: The object table’s object identifier is invalid
Cause: The character string representing the table’s object identifier could not be converted to an internal object identifier.
Action: Internal error.

Back to previous menu

IMP-00071: Object identifier of imported table mismatches object identifier of existing table

oracle

IMP-00071: Object identifier of imported table mismatches object identifier of existing table
Cause: An attempt was made to import data into a table that was recreated under a different object identifier than the object identifier used for the exported object table. Under this situation, REF’s to this table that are contained within the dump file will also be invalid.
Action: Drop the offending object table prior to import.

Back to previous menu

IMP-00070: Lob definitions in dump file are inconsistent with database

oracle

IMP-00070: Lob definitions in dump file are inconsistent with database
Cause: The number of LOBS per row in the dump file is different than the
* number of LOBS per row in the table being populated.
Action: Modify the table being imported so that it matches the column
* attribute layout of the table that was exported.

Back to previous menu

IMP-00069: Could not convert to environment national character set’s handle

oracle

IMP-00069: Could not convert to environment national character set’s handle
Cause: Internal error..
Action: Contact Worldwide support.

Back to previous menu

IMP-00068: Could not find environment national character set

oracle

IMP-00068: Could not find environment national character set
Cause: An environment national character set was specified that was not recognized by the Import utility.
Action: Ensure that the spelling of the national character set specified in the environment variable NLS_NCHAR is correct.

Back to previous menu

IMP-00067: Could not convert to server character set’s handle

oracle

IMP-00067: Could not convert to server character set’s handle
Cause: Internal error.
Action: Contact Worldwide support.

Back to previous menu

IMP-00066: Missing NLS_CHARACTERSET in props$

oracle

IMP-00066: Missing NLS_CHARACTERSET in props$
Cause: No value for NLS_CHARACTERSET in props$.
Action: Contact Worldwide support.

Back to previous menu

IMP-00065: Import is unable to recreate lobs within objects

oracle

IMP-00065: Import is unable to recreate lobs within objects
Cause: An error occurred recreating a LOB within an imported object.
Action: Report this to Oracle Worldwide Support as an Import internal error.

Back to previous menu

IMP-00064: Definition of LOB was truncated by export

oracle

IMP-00064: Definition of LOB was truncated by export
Cause: While producing the dump file, Export was unable to write the
* entire contents of a LOB. Import is therefore unable to
* reconstruct the contents of the LOB. The remainder of the
* import of the current table will be skipped.
Action: Delete the offending row in the exported database and retry the
* export.

Back to previous menu

IMP-00063: Warning: Skipping table “string”.”string” because object type “string”.”string” cannot be created or has different identifier

oracle

IMP-00063: Warning: Skipping table “string”.”string” because object type “string”.”string” cannot be created or has different identifier
Cause: An error occurred creating an object type that is used by the
* table.
Action: Examine the import log to determine why the object type could not
* be created. If the object type already existed, with a
* different object identifier, then drop the object type and
* retry the import.

Back to previous menu