Category Archives: IMP Database Error Messages

IMP-00041: Warning: object created with compilation warnings

oracle

IMP-00041: Warning: object created with compilation warnings
Cause: The object in the SQL statement following this error was created with compilation errors. If this error occurred for a view, it is possible that the base table of the view was missing.
Action: This is a warning. The object may have to be recompiled before being used.

Back to previous menu

IMP-00040: FILESIZE does not match the value used for export: string

oracle

IMP-00040: FILESIZE does not match the value used for export: string
Cause: The value specified for FILESIZE does not match the value specified during the creation of the export file.
Action: If you believe the specified FILESIZE value is correct, verify that you specified the correct file for import. If you specified the correct file but are unsure about the correct value, re-execute the import command but specify FILESIZE=0.

Back to previous menu

IMP-00039: VOLSIZE does not match the value used for export: string

oracle

IMP-00039: VOLSIZE does not match the value used for export: string
Cause: The value specified for VOLSIZE does not match the value specified during the creation of the export file.
Action: If you believe that the specified VOLSIZE value is correct, verify that you specified the correct file for import. If you specified the correct file but are unsure about the correct value, re-execute the import command but specify VOLSIZE=0.

Back to previous menu

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

oracle

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

Back to previous menu

IMP-00037: Character set marker unknown

oracle

IMP-00037: Character set marker unknown
Cause: The export file is corrupted.
Action: Try to obtain an uncorrupted version of the export file. If the export file is not corrupted, report this as an Import internal error and submit the export file to customer support.

Back to previous menu

IMP-00036: Could not find environment character set

oracle

IMP-00036: Could not find environment character set
Cause: An environment character set was specified that was not recognized by the Import utility.
Action: Ensure that the spelling of the character set specified in the command line parameter CHARSET (for Release 6 only) or the environment variable NLS_LANG is correct.

Back to previous menu

IMP-00035: input file string must be on a disk

oracle

IMP-00035: input file string must be on a disk
Cause: On some platforms, import can read files from tape. This message is displayed if the first file in an export file set was on disk and you specified a tape device for a second or subsequent file.
Action: Verify that you have specified the correct file name for the import file. Remember that all input files can be either on disk or all files can be on tape, but not mixed both tape and disk.

Back to previous menu

IMP-00034: Warning: FromUser “string” not found in export file

oracle

IMP-00034: Warning: FromUser “string” not found in export file
Cause: The user specified a FROMUSER name that does not exist in export file.
Action: Correct the FROMUSER specification.

Back to previous menu

IMP-00033: Warning: Table “string” not found in export file

oracle

IMP-00033: Warning: Table “string” not found in export file
Cause: A table name was specified that does not exist in export file.
Action: Correct the table specification.

Back to previous menu

IMP-00032: SQL statement exceeded buffer length

oracle

IMP-00032: SQL statement exceeded buffer length
Cause: The buffer was too small for the SQL statement being read.
Action: Rerun with a larger buffer. This can also be an indication of a corruption in the import datafile.

Back to previous menu