Problem Exporting/Importing a Table
Posted on 2008-06-19
Hello everyone. I have a table, which contains roughly 3000 rows. I am able to do a full export of the table with no error messages, but when I try and import the export file, I get this error:
imp-00064: Definition of LOB was truncated by export
IMP-00028: partial import of previous table rolled back: 3011 rows rolled back
If I query the table in question after the import, there are no rows.
If I Google this error, it says "Delete the offending row in the exported database and retry the export". I was wondering how would I know what the offending row is if I don't get any errors during the export? Thanks in advance.