Home » RDBMS Server » Server Utilities » Re: Error IMP-00020: what is the problem?
Re: Error IMP-00020: what is the problem? [message #368075] Mon, 06 March 2000 11:50
Mo
Messages: 5
Registered: March 2000
Junior Member
IF THE TABLE TO BE IMPORTED HAS A LONG/LONG RAW COLUMN:

The import buffer is not large enough to hold the LONG/LONG RAW data.

1) Set the following in the import:
BUFFER = (row_in_array)*(max_row_size).
COMMIT = y.

2) If this still does not resolve the problem, it is possible that the export file is corrupt. A way to check this is to re-export the problematic
table and try the import again.

If your row exceeds the buffer limit given in the Installation User's Guide, then the workaround to load in the data is to design a PRO*C application.

IF THE TABLE TO BE IMPORTED DOES NOT HAVE A LONG/LONG RAW COLUMN:
There is a bug that has been filed on this issue (#230777). Follow workaround (2) described above.
Previous Topic: Big Money for Oracle 8 Certification Materials
Next Topic: Help needed regarding SQL*Loader
Goto Forum:
  


Current Time: Mon May 23 21:13:40 CDT 2022