Oracle Import Buffer Size

[mtcutler]

I tried to import a dump file from a prior export using PL/SQL Developer. I get the following error in the log tab:

IMP-00032: SQL statement exceeded buffer length

Online Oracle search says buffer size of 1MB should fix this. PL/SQL Developer won't let me specify a buffer size greater than 80KB on the Oracle Import tab of Import Tables window. Any idea how to make the buffer size greater?

I am having trouble doing import from command line, and prefer to use PL/SQL Developer.

 

[Marco Kalter]

I'm not sure why this limitation exists. We'll check it out.

 

[mtcutler]

Thanks. I was able to get DOS command prompt Oracle import to work with a parfile using the same parameters produced by PL/SQL Developer in the Log window. I just changed the buffer size to 1000000 from 80000. The same error occurred from the command line import using 80000 as the error reported in PL/SQL Developer.

It would be nice if PL/SQL Developer allowed the higher import buffer size from the screen.