How to fix the Oracle error IMP-00064: Definition of LOB was truncated by export?

In this post, you’ll learn more about the Oracle ErrorIMP-00064: Definition of LOB was truncated by export with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

IMP-00064: Definition of LOB was truncated by export

Reason for the Error IMP-00064: Definition of LOB was truncated by export

While producing the dump file, Export was unable to write the

* entire contents of a LOB. Import is therefore unable to

* reconstruct the contents of the LOB. The remainder of the

* import of the current table will be skipped.

How to fix the Error IMP-00064: Definition of LOB was truncated by export ?

You can fix this error in Oracle by following the below steps

Delete the offending row in the exported database and retry the

* export.