How to fix the Oracle error IMP-00070: Lob definitions in dump file are inconsistent with database.?

In this post, you’ll learn more about the Oracle ErrorIMP-00070: Lob definitions in dump file are inconsistent with database. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

IMP-00070: Lob definitions in dump file are inconsistent with database.

Reason for the Error IMP-00070: Lob definitions in dump file are inconsistent with database.

The number of LOBS per row in the dump file is different than the

* number of LOBS per row in the table being populated.

How to fix the Error IMP-00070: Lob definitions in dump file are inconsistent with database. ?

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

Modify the table being imported so that it matches the column

* attribute layout of the table that was exported.