IMP-00032 error encountered during Oracle Import

When PL/SQL is used for import, an error occurs:

IMP-00032: the SQL statement exceeds the buffer length.

IMP-00008: the exported file contains unrecognized statements.

At first, I thought it was because the Large_Pool settings of the database were not large enough. Therefore, after large_pool_size = 33554432 was set, the import was performed. The same error was returned again.

Start from scratch and search for the internet. I have a prompt that the buffer needs to be increased during the import. I think about it later. No configuration needs to be modified during the previous import. The imported user contains a partition table with a large data volume, is this the reason?

Next, let's take a closer look at the graphic interface for importing data in PL/SQL. The preceding figure shows the setting items of "Buffer Size", such:

Test and solution:

First operation: the Buffer size is 32 KB and the above error is prompted;

The second operation: the Buffer size is kb, and the import is successful;

The third operation: the Buffer size is 80 KB, and the import is successful;

The fourth operation: the Buffer size is 60 kb and the above error is prompted;

Conclusion: careless !! In graphic interface operations, you can pay more attention to some configuration options during interface operations!