IMP-00020: long column too large for column buffer size (number)
Cause: The column buffer is too small. This usually occurs when importing LONG data.
Action: Increase the insert buffer size 10,000 bytes at a time (for example). Use this step-by-step approach because a buffer size that is too large may cause a similar problem.
IMP-00019: row rejected due to ORACLE error number
Cause: Import encountered the referenced Oracle error while trying to import a row.
Action: Look up the accompanying Oracle message in the ORA message chapters of this manual and take appropriate action.
IMP-00018: partial import of previous table completed: number rows imported
Cause: A table was only partially imported because of an Oracle error.
Action: Look up the accompanying Oracle message in the ORA message chapters of this manual and take appropriate action.
IMP-00017: following statement failed with ORACLE error number:
Cause: Import failed to execute the statement from the export file because of an Oracle error.
Action: Look up the accompanying Oracle message in the ORA message chapters of this manual and take appropriate action.
IMP-00016: required character set conversion (type number to number) not supported
Cause: Import could not convert the character format of the export file into the native character format.
Action: Change the user character set by setting the NLS_LANG environment variable to match the character set of the export file.
IMP-00015: following statement failed because the object already exists:
Cause: Import failed to create an object because it already exists.
Action: Specify IGNORE=Y to ignore such errors and import rows even when tables are not created because they already exist.
IMP-00014: option “string” is needed, but not present in database
Cause: The command entered requires the specified option. Either that option is not installed, or the row describing the option is missing from table V$OPTION
Action: Reinstall Oracle with the option specified by the message.
IMP-00013: only a DBA can import a file exported by another DBA
Cause: The privileges needed to Import an export file generated by a database administrator do not exist. Only a database administrator can import such files.
Action: Ask the database administrator to do the import.
IMP-00012: invalid export mode (character) in header
Cause: The Export mode specified in the export file header is invalid.
Action: Check the export file to see if it was corrupted. If it was not, report this as an Import bug and submit the export file to customer support.
IMP-00011: formatted table data not currently supported
Cause: You tried to import an export file that contains formatted table data. Import only supports export files containing binary table data. wher
Action: Retry using an export file that contains only binary table data.