Category Archives: IMP Database Error Messages

IMP-00082: Error during conversion ROWID from string format to internal

oracle

IMP-00082: Error during conversion ROWID from string format to internal
Cause: An error occured while attempting to to convert a ROWID from an export dump file into an internal format.
Action: Report this to Oracle Worldwide Support as an Import internal error.

Back to previous menu

IMP-00081: attempt to free unallocated memory

oracle
IMP-00081: attempt to free unallocated memory
Cause: An attempt was made to free memory that was not allocated.
Action: Contact Oracle Worldwide Support

Back to previous menu

IMP-00080: Error during character conversion of long column or long command

oracle

IMP-00080: Error during character conversion of long column or long command
Cause: During piecewise character conversion of the data in a long column or of a long command, a fatal conversion error occurred. Either character truncation occurred or an invalid character set handle was used.
Action: Retry the import with a different character set.

Back to previous menu

IMP-00079: Warning: National character set data in this table may be incorrect

oracle

IMP-00079: Warning: National character set data in this table may be incorrect
Cause: Due to a problem in 8.0.2 Export, national character data in NCHAR and NVARCHAR2 columns was incorrectly assumed to be in the export server’s data base character set and was converted to the export client’s data base character set. This conversion would only be correct if the export server’s data base character set was the same as the export server’s national character set and the export client’s data base character set was the same as the export client’s national character set. All other combinations would likely be incorrect. This export dump file was generated by 8.0.2 Export and the export client and server characater sets did not fit that criteria.
Action: Examine the national character data. If incorrect, update the data with correct data.

Back to previous menu

IMP-00078: Cannot translate FILE locator to “string” “string” in server character set

oracle

IMP-00078: Cannot translate FILE locator to “string” “string” in server character set
Cause: (1) The current export dump file was generated using Beta-2 of Oracle8.0 AND (2) there was a File that appeared as an an attribute of an ADT within a table’s column AND (3) the character set of the export server’s database was different than the character set of the import server’s database AND (4) when the filename or the aliasname of the File increased in size when it was translated to the character set of the import server. When all of these conditions are true, translation of the strings could yield corruption of the data in the column. Rather than proceeding with the translation, import will leave the character strings in the File in the old character set.
Action: After import completes, rename the directory aliases and external filenames to match the real names used for the target database.

Back to previous menu

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

oracle

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

Back to previous menu

IMP-00076: Missing NLS_NCHAR_CHARACTERSET in props$

oracle

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

Back to previous menu

IMP-00075: Warning: The nested table may contain partial rows or duplicate rows

oracle

IMP-00075: Warning: The nested table may contain partial rows or duplicate rows
Cause: An error occurred inserting data into an outer or inner nested table. If the error occurred in the outer table, rows are still inserted into the inner tables. If the error occurred in an inner table, data is still inserted into the outer table and other inner tables. This can result in duplicate inner table rows or partial logical rows.
Action: Examine the data in the tables. Delete the incorrect rows or drop the entire table and perform the import again.

Back to previous menu

IMP-00074: The constraints flagged by ALL_CONSTRAINTS.BAD will break in 2000 A.D

oracle

IMP-00074: The constraints flagged by ALL_CONSTRAINTS.BAD will break in 2000 A.D
Cause: Constraints exist in the data base that specify date values without fully specifying the year. These constraints could break in the year 2000 A.D.
Action: Query ALL_CONSTRAINTS and correct those constraints marked as bad.

Back to previous menu

IMP-00073: FILE locator “string” “string” is truncated to “string” “string” in server character set

oracle

IMP-00073: FILE locator “string” “string” is truncated to “string” “string” in server character set
Cause: The conversion of the specified directory and name strings for a file attribute or column from the export server’s character set into the import server’s character set exceeded the maximum string lengths allowed within FILE descriptors. The strings will be truncated to the maximum supported lengths.
Action: Rename the directory aliases and external filenames to match the truncated names in the specified FILE column or attribute.

Back to previous menu