IMP-00032: SQL statement exceeded buffer length

IMP-00032: SQL statement exceeded buffer length

IMP-00008: unrecognized statement in the export file:


SOLUTION:
use BUFFER parameter with import command.

Note: use MAXIMUM value for BUFFER parameters eg: BUFFER=1000000
also use commit=y

You can skip to the end and leave a response. Pinging is currently not allowed.

4 Responses to “IMP-00032: SQL statement exceeded buffer length”

  1. Mohan says:

    Can you please give this command along with one one example import statement

  2. imp user/password file=< 'Dump file location'> fromuser= touser= log= BUFFER=1000000 commit=y

    EXAMPLE:

    imp mohan/mohanpwd file='/u01/dump_dir/test.dmp' fromuser=SCOTT touser=Mohan log=/u01/dump_dir/test_imp.log BUFFER=1000000 commit=y

    Note: You can find all imp/exp parameters by using below command:

    imp help=y
    exp help=y

    If you have any query, feel free to ask.

  3. Mohan says:

    Thanks rishi ,

Leave a Reply