I'm trying to make an import of a database but I get this error:
Imp-00009 Abnormal end of export file Imp-00020 Long column too large for column buffer size(7)
The import creates four tables and creates the rows for three of them, I guest that when the import tries to create the rows for the last table is when I get the error.
I try to use the "Buffer=100000" parameter in the import command with the same result.
Any ideas? Thanks!
According to Oracle documentation:
IMP-00009: abnormal end of export file Cause: The export file is probably from an aborted Export session. Action: If so, retry the export and import. Otherwise, report this as an Import bug and submit the export file that caused this error to customer support.
As as result, a corrupted export file is rather possible. However, if a corrupted export file is not the case then according to:
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.
You could try increasing the buffer size 10000 bytes a a time, because as the documentation says, too long bugger size can cause the same message.